In the last episode (Mar 27), Paul Halliday said: > 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
You want GROUP_CONCAT: http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_group-concat -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
