List:General Discussion« Previous MessageNext Message »
From:Christian Hansel Date:June 13 2007 4:40pm
Subject:building comma-separated list of strings from subquery
View as plain text  
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
Thread
building comma-separated list of strings from subqueryChristian Hansel13 Jun
RE: building comma-separated list of strings from subqueryChristian Hansel13 Jun
  • Re: building comma-separated list of strings from subqueryBrent Baisley13 Jun