mysql groupby字符串拼接

使用group_concat聚合函数将字符串拼接起来：

select buyer_id,group_concat(query)  from order_source where query !="" group by buyer_id ;

buyer_id | query                                                                                                                                                                                                   |
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|   757069 | 纸品,,斜挂包女

参考链接：

https://blog.youkuaiyun.com/weixin_40283570/article/details/80366911