How to collapse rows into a comma-delimited list in an SQL Query in MySql

Question

It is relatively simple in T-SQL to concatenate related values into a comma delimited string in an SQL Query (see here: What is the best way to collapse the rows of a SELECT into a string? and here: What is the best way to collapse the rows of a SELECT into a string?). The latter link describes exactly what I need to do, but I need to do it in MySql, and the query that works in T-SQL doesn't work in MySql. Any MySql experts out there know how to do this?

Thanks!

ajreal · Accepted Answer · 2010-12-18 00:06:21Z

5

select group_concat(your_id) from your_table

answered Dec 18, 2010 at 0:06

ajreal

47.4k11 gold badges98 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Just found this - but you win! Thanks!