Mysql查找重复记录（自己收藏）

SELECT title
FROM jos_content
WHERE title
IN (

SELECT title
FROM jos_content
GROUP BY title
HAVING count( title ) >1

)
LIMIT 0 , 30