php - 如何从id重复的数据库mysql中获取重复条目

Question

我想从 mysql 返回重复的 id这是我的查询

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

结果是这样的:

duplicate_Count  title id2     text     1213     text_2    233

但我想要这样的结果:

duplicate_Count  title id2     text     121 , 1223     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