最近帮小伙伴网站采集的时候才知道有这个问题,我猜想下原因,应该是发布太快,服务器配置低,再加上网络问题,导致部分内容延迟了发布,实际上第一次已经成功发布了的。

我开始是让他在后台手动对比,量太大了,才看能不能批量删除了。

就找到了这段代码:

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' 

在数据库里面执行下就行了。