语法:
group_concat( [DISTINCT] 要连接的字段 [Order BY 排序字段 ASC/DESC] [Separator ‘分隔符’] )
1.看栗子:
SELECT id,obyrid,obyrname,uname FROM eshop_obyr WHERE danwei='zwyzy';
2.把obyrid重复的unmae 拼接在一起(默认“,”)
SELECT id,obyrid,obyrname,GROUP_CONCAT(uname) FROM eshop_obyr WHERE danwei='zwyzy' GROUP BY obyrid ;
3.把obyrid重复的unmae 用“?”拼接
SELECT id,obyrid,obyrname,GROUP_CONCAT(uname SEPARATOR '?') FROM eshop_obyr WHERE danwei='zwyzy' GROUP BY obyrid ;
4.把obyrid重复的unmae 用“,”拼接去重
SELECT id,obyrid,obyrname,GROUP_CONCAT(DISTINCT uname ) FROM eshop_obyr WHERE danwei='zwyzy' GROUP BY obyrid ;
5.把obyrid重复的unmae 用“,”拼接去重 升序
SELECT id,obyrid,obyrname,GROUP_CONCAT(DISTINCT uname ORDER BY uname ASC ) FROM eshop_obyr WHERE danwei='zwyzy' GROUP BY obyrid ;