building comma-separated list of strings from subquery

[Christian Hansel]

Hi y'all,

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