WordPress MYSQL数据库操作删除重复的文章 4-5万数据基本无延迟 速度超快

WordPress MYSQL数据库操作删除重复的文章 

DELETE a.* FROM wp_posts AS a INNER JOIN ( SELECT post_title, MIN( id ) AS min_id FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY post_title HAVING COUNT( * ) > 1 ) AS b ON b.post_title = a.post_title AND b.min_id <> a.id AND a.post_type = 'post' AND a.post_status = 'publish'

备注：以上 mysql执行语句 wp_posts 字段需要改成 自己数据库的字段名

转载于:https://my.oschina.net/jkeabc/blog/769691