且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何删除WordPress中的重复帖子

更新时间:2023-12-01 23:07:16

建议您先尝试备份您的SQL数据库,然后再尝试以下操作。

I advise backing up your SQL database before trying the below.

尝试:

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

由于上述代码未经测试,因此可以尝试复制帖子删除器

As the above code is untested, you could try the Duplicate Post Remover.