DELETE from `table`
WHERE `table`.id in
(SELECT a.id from
(SELECT id FROM `table`
WHERE `条件一`
and `条件二`
and `条件三`
GROUP BY `字段名` HAVING COUNT(字段名) >1) AS a);
DELETE from `table`
WHERE `table`.id in
(SELECT a.id from
(SELECT id FROM `table`
WHERE `条件一`
and `条件二`
and `条件三`
GROUP BY `字段名` HAVING COUNT(字段名) >1) AS a);