Mysql查询某字段值重复的数据

select title,count(*) as count from author group by title having count>1;