On Tue, Mar 27, 2012 at 3:43 PM, Dan Nelson <dnelson@stripped> 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/
