From: Paul Halliday
Date: March 27 2012 5:23pm
Subject: Group expansion as part of the result
List-Archive: http://lists.mysql.com/mysql/227056
Message-Id: <CAJfn-RG4hd_gqjnTcMwBzDcdEqm9HJdqvXh7vwdtUcatOqxNUw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

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.