On Tue, Mar 27, 2012 at 3:43 PM, Dan Nelson <dnel...@allantgroup.com> wrote: > 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: >
Heh, and exactly how I wanted it formatted. Great! Thanks. -- Paul Halliday http://www.squertproject.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
