138 reputation
18
bio website
location France
age 37
visits member for 1 year, 10 months
seen Feb 21 '13 at 9:40

May
21
awarded  Popular Question
Feb
22
awarded  Notable Question
Nov
7
awarded  Popular Question
Sep
6
comment How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Fixed it. See my answer. Thanks for helping out!
Sep
6
accepted How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Sep
5
answered How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Aug
30
comment How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Thanks for the input so far. Good idea with length, but I tested running the query on a single article, which should only return: "s,m,l,xl" and I get "s,xl". So you are probably correct about the inherent error... :-)
Aug
30
asked How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Jul
24
awarded  Commentator
Jul
24
comment Slow performance of MySQL Join Query
Thanks for the answer and help so far! I found the table had no index at all... I added one and went from scanning 60k+ rows to 23. I will post the show create sometime today.
Jul
11
comment Slow performance of MySQL Join Query
@ypercube: do you want to make "use EXPLAIN" an answer. First time I did, no index on the table, added an index. Down to a few milliseconds. THANKS
Jul
11
revised Slow performance of MySQL Join Query
added 539 characters in body
Jul
11
comment Slow performance of MySQL Join Query
can't get it to work from Coldfusion and since I'm working remote on the MySQL database I don't have edit privileges... any idea how to get the info, I'm looking for?
Jul
11
comment Slow performance of MySQL Join Query
where do I add this?
Jul
11
asked Slow performance of MySQL Join Query
Jul
3
awarded  Tumbleweed
Jun
25
awarded  Scholar
Jun
25
awarded  Editor
Jun
25
accepted Can I execute a prepared statement inside a MySQL SELECT?
Jun
25
revised Can I execute a prepared statement inside a MySQL SELECT?
added 1925 characters in body