>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

 

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

Reply via email to