如何从ID为mysql数据库重复条目重复

Question

，我想回去IDS从MySQL 重复，这是我的查询

>  SELECT COUNT(title) AS duplicate_Count , title , id 
>  FROM lyric 
>  GROUP BY title 
>  HAVING COUNT(title) > 1 

和结果是这样的：

 
duplicate_Count title id 
2  text  121 
3  text_2 233 

但我想这样的结果：

 
duplicate_Count title id 
2  text  121 , 122 
3  text_2 233 ,260 ,56 

任何帮助，请

Answer 1

变化id到GROUP_CONCAT(id)：

SELECT COUNT(title) AS duplicate_Count , title , GROUP_CONCAT(id) 
FROM lyric 
GROUP BY title 
HAVING COUNT(title) > 1 

Example