mysql 删除相同的字段内容

DELETE FROM new_collects
WHERE id IN
(SELECT id FROM (SELECT id FROM new_collects GROUP BY content HAVING count(*) > 1)e);