我希望从MySQL返回重复的id。这是我的查询
> SELECT COUNT(title) AS duplicate_Count , title , id
> FROM lyric
> GROUP BY title
> HAVING COUNT(title) > 1
结果是这样的:
duplicate_Count标题编号2 文本 1213 text_2 233
但我想要这个结果:
duplicate_Count标题编号2 文本 121 , 1223 text_2 233 ,260 ,56
请提供任何帮助
将id
更改为GROUP_CONCAT(id)
:
SELECT COUNT(title) AS duplicate_Count , title , GROUP_CONCAT(id)
FROM lyric
GROUP BY title
HAVING COUNT(title) > 1
例