You probably want to look at the group_concat function. It doesn't work
as a subselect, but it allows you to group a set of records and "rollup"
the different values in the grouping.

Christian Hansel wrote:
>> 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
>
>
> P.S. sorry for double-cross-wrong posting this to another thread
>
>