179 reputation
5
bio website
location
age
visits member for 1 year, 3 months
seen Feb 27 at 22:03

Feb
24
revised Getting the exact edited data from a column in SQL Server
Removed MySQL tag. Question is about SQL-Server.
Feb
23
revised sql server-percentage calculation
Removed MySQL tag. Question is about SQL-Server.
Feb
23
suggested suggested edit on Getting the exact edited data from a column in SQL Server
Feb
23
suggested suggested edit on sql server-percentage calculation
Feb
23
awarded  Organizer
Feb
23
revised importing database backup to phpmyadmin return #1064
Removed SQL-Server tag. Question is about MySQL.
Feb
23
suggested suggested edit on importing database backup to phpmyadmin return #1064
Feb
2
comment How can I search a column in MySQL containing unix timestamps with a query referencing a different format?
@GordThompson I changed the answer. Your query was indeed more efficient. It saved 2 ms in this same example alone.
Feb
2
revised How can I search a column in MySQL containing unix timestamps with a query referencing a different format?
added 99 characters in body
Feb
1
answered How can I search a column in MySQL containing unix timestamps with a query referencing a different format?
Feb
1
awarded  Supporter
Feb
1
comment Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
Hey, I wish I could solve your question with a query. If I can come up with something I will let you know. But for now I think that the best solution by far is to use PHP. Good luck with your project.
Feb
1
comment Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
@jozenovak group_concat does indeed have a limit. You can alter the limit by using SET [GLOBAL | SESSION] group_concat_max_len = type in a value;. See SO stackoverflow.com/questions/5445048/…. However at some point it will also truncate your output. You could try to create a temporal table. I have tried both action before, so I will need to read up on that to answer your question. A less complicate option will probably be to use php to split up the query.
Feb
1
awarded  Commentator
Feb
1
comment Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
@jozenovak I am a bit puzzled is this what you need sqlfiddle.com/#!2/5ce07/53. If not could you explain your question by showing the results you need?
Jan
29
revised Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
Reformat SQL query
Jan
29
suggested suggested edit on Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
Jan
27
answered Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
Jan
26
comment How can I best combine 3 queries into 1?
@nick is you problem solved? Or do you still need help?
Jan
24
comment Select multiple columns in subquery
@BradleyWeston list one engine based on what? You need to define a decision rule on which basis this engine is selected. For example, if you want the first one that appears in the query? -> Use LIMIT.