You probably want to look at the group_concat function. It doesn't work as a subselect, but it allows you to group a set of records and "rollup" the different values in the grouping.

Christian Hansel wrote:
I'ld like to accomplish something like:

set @myvar=concat_ws(",",(SELECT column from table1 order by column;
where ...))

or

select concat_ws(",",(SELECT column from table1 order by column where ...));

for further usage in sql-scripts

I forgot to mention: As I need it in a function, i think i cant use the
 second version.

Does anyone know of a way to build a comma-separated list aka "set" from rows
of a table?

Any suggestions welcome!

TIA


P.S. sorry for double-cross-wrong posting this to another thread

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

Reply via email to