mysql 删除数据库title重复内容

delete from article where id  in ( select id from (select id from article group by title having count(title) > 1)  as  a)