| bio | website | |
|---|---|---|
| location | France | |
| age | 36 | |
| visits | member for | 11 months |
| seen | Feb 21 at 9:40 | |
| stats | profile views | 8 |
|
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? |
|
Aug 2 |
comment |
Can I do a MySQL subquery across criteria with different number of results Don't have one yet. Is this the problem? |
|
Aug 1 |
asked | Can I do a MySQL subquery across criteria with different number of results |
|
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 26 |
asked | Can I use MySQL to check for multiple patterns with related elements (like S=2,M=4,L=2)? |
|
Jun 25 |
awarded | Scholar |