mysql合并某字段相同元素,其余字段逗号 连接 SELECT GROUP_CONCAT(`lowname`) as name1, lowname FROM table group by lowname;