DELETE from `news` WHERE ( `newsName` ) in
(SELECT `newsName` from (SELECT `newsName` FROM `news` GROUP BY `newsName` HAVING COUNT(*)>1) s1)
AND `newsId` NOT in (SELECT `newsId` from (SELECT `newsId` FROM `news` GROUP BY `newsName` HAVING COUNT(*)>1) s2);
news 是数据库名字
newsName查重复的字段
newsId 数据库的id