List:General Discussion« Previous MessageNext Message »
From:Christian Hansel Date:June 13 2007 4:46pm
Subject:RE: partial string extraction with sql using regexp ?
View as plain text  
>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

 
Thread
partial string extraction with sql using regexp ?Christian Hansel13 Jun
RE: partial string extraction with sql using regexp ?Christian Hansel13 Jun