RE: partial string extraction with sql using regexp ?

[Christian Hansel]

>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