Is there a way to have SELECT return sets for rows that were grouped
together? So if I had a table like:
Table:
ID DATA
1 a
1 b
2 X
2 Y
3 10
3 20
I want to do something like this:
SELECT MAKE_SET(-1,DATA) as LIST
FROM Table
GROUP BY ID
ID DATA
1 a,b
2 X,Y
3 10,20
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
