Say I have:

SELECT COUNT(name), name, COUNT(DISTINCT(status)) FROM table GROUP BY name

and it returns:

20 paul 5
19 john 2
75 mark 3

is there a way to return what comprises DISTINCT(status) as part of the result?

so:

20 paul 2,3,1,20,9
19 john 20,9
75 mark 1,20,9

Thanks.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql