1.看例子:
SELECT id,obyrid,obyrname,uname FROM eshop_obyr WHERE danwei='zwyzy';
结果:
2.把obyrid相同的uname 拼接到一起(“,”默认)
SELECT id,obyrid,obyrname,GROUP_CONCAT(uname) FROM eshop_obyr WHERE danwei='zwyzy' GROUP BY obyrid ;
结果:
3.用“?”拼接
SELECT id,obyrid,obyrname,GROUP_CONCAT(uname SEPARATOR'?') FROM eshop_obyr WHERE danwei='zwyzy' GROUP BY obyrid ;
结果:
4.去除重复DISTINCT
SELECT id,obyrid,obyrname,GROUP_CONCAT(DISTINCT uname) FROM eshop_obyr WHERE danwei='zwyzy' GROUP BY obyrid ;
5.obyrid相同的 把uname ,逗号拼接,去重 按照uname 升序排列
SELECT id,obyrid,obyrname,GROUP_CONCAT(DISTINCT uname ORDER BY uname ASC) FROM eshop_obyr WHERE danwei='zwyzy' GROUP BY obyrid ;
结果