mysql 使用 groupby字符串拼接

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

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

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