分组后使用GROUP_CONCAT()函数对字段拼接,默认是英文逗号,可自定义
SELECT
-- 把0和空数据转为null
GROUP_CONCAT( DISTINCT CASE address WHEN '0' OR '' THEN NULL ELSE address END SEPARATOR ',' ) address
-- 正常处理
-- GROUP_CONCAT( DISTINCT address SEPARATOR ',' ) address
FROM
USER
GROUP BY
NAME
HAVING
count( NAME )> 1