帮助中心帮助中心

帮助分类
帮助中心
文档首页> 帮助中心> wordpress如何一次性去除标题重复文章

wordpress如何一次性去除标题重复文章

发布时间:2025-05-18 19:20       

第一种:插件法。

通过在后台安装去复重文章插件Delete Duplicate Posts,可以去除标题重复的文章,只保留一篇不重复的。

第二种方法:通过SQL代码的方法

(1)去除重复文章,只保留一篇

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

(2)去除重复文章,一片都不保留

    1. 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);
    2. DELETE FROM wp_posts WHERE ID IN (SELECT col1 FROM my_tmp);
    3. DROP TABLE my_tmp;

(3)另一种去除所有重复文章的方法

    1. 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框里,然后执行就可以了。(注意:操作之前,请先进行网站备份)