mysql查询重复数据

SELECT id,utype,title,upvideo FROM course_data WHERE title IN(
SELECT title FROM course_data GROUP BY title HAVING COUNT(title) > 1
) order by title asc;