MySQL group-by 与逗号分隔列表

Question

我有以下数据

id category_id bookmark_id
1      1           1
2      2           1
3      3           1
4      4           2
5      5           1

mysql查询是

SELECT * from table_name group by bookmark_id

返回

id category_id   bookmark_id
1     1             1
4     4             2

这很好

但我想要多一栏

id category_id category_list bookmark_id
1    1           1,2,3,5         1
4    4             4             2

知道如何实现上述结果吗？

Answer 1

select min(category_id) as min_cat, 
       group_concat(distinct category_id order by category_id) as category_list, 
       bookmark_id
from your_table
group by bookmark_id