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]