wordpress删除重复的帖子或页面

DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
group by post_title
having count(*) > 1
) as good_rows on good_rows.post_title = bad_rows.post_title
and good_rows.min_id <> bad_rows.id

 

注意：上面的例子是当您使用“wp_”作为表名前缀时。另外，请注意，在运行此MySQL查询之前，您确实应该备份您的网站。如果你不这样做，事情可能会变得非常糟糕。

经常遇到的一个常见问题是在WordPress中创建重复的帖子。这通常发生在您开始使用自动化插件和/或通过RSS将内容馈送到您的博客后。

DELETE bad_rows . * FROM ktz3_posts AS bad_rows INNER JOIN (
  SELECT post_title, MIN( id ) AS min_id
  FROM ktz3_posts
  GROUP BY post_title
  HAVING COUNT( * ) >1
  ) AS good_rows ON good_rows.post_title = bad_rows.post_title
AND good_rows.min_id <> bad_rows.id