对于使用WordPress构建的网站，特别是那些依赖于采集数据填充内容的站点，经常会面临内容重复的问题。重复的文章内容不仅影响用户体验，还可能对网站的搜索引擎排名造成负面影响。因此，有效地删除这些重复文章是维护网站健康的关键步骤之一。

以下是二种一次性去除标题重复文章的方法：

去除重复文章保留一篇

CREATE TABLE my_tmp AS SELECT MIN(ID) AS col1 FROM wp_posts GROUP BY post_title; DELETE FROM wp_posts WHERE ID NOT IN (SELECT col1 FROM my_tmp); DROP TABLE my_tmp;

去除重复文章一篇不保留

CREATE TABLE my_tmp AS Select ID AS col1 From wp_posts Where post_title In (Select post_title From wp_posts Group By post_title Having Count(*)>2); DELETE FROM wp_posts WHERE ID IN (SELECT col1 FROM my_tmp); DROP TABLE my_tmp;

去除所有重复文章的方法

CREATE TABLE my_tmp AS Select ID AS col1 From wp_posts Where post_title In (Select post_title From wp_posts Group By post_title Having Count(*)>2);DELETE FROM wp_posts WHERE ID IN (SELECT col1 FROM my_tmp); DROP TABLE my_tmp;

操作方法很简单，只需将上面的SQL语句，放到自己网站数据库的 SQL框里，然后执行就可以了。

感谢您的来访，获取更多精彩文章请收藏本站。