wordpress如何一次性去除标题重复文章
发布时间:2025-05-18 19:20       
第一种:插件法。
通过在后台安装去复重文章插件Delete Duplicate Posts,可以去除标题重复的文章,只保留一篇不重复的。

第二种方法:通过SQL代码的方法
(1)去除重复文章,只保留一篇
- 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;
(2)去除重复文章,一片都不保留
- 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;
(3)另一种去除所有重复文章的方法
- 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框里,然后执行就可以了。(注意:操作之前,请先进行网站备份)
