幫助中心幫助中心
wordpress如何一次性去除標(biāo)題重復(fù)文章
發(fā)布時間：2025-05-18 19:20
第一種：插件法。
通過在后臺安裝去復(fù)重文章插件Delete Duplicate Posts，可以去除標(biāo)題重復(fù)的文章，只保留一篇不重復(fù)的。
第二種方法：通過SQL代碼的方法
（1）去除重復(fù)文章，只保留一篇
- 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）去除重復(fù)文章，一片都不保留
- 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）另一種去除所有重復(fù)文章的方法
- 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語句，放到自己網(wǎng)站數(shù)據(jù)庫的 SQL框里，然后執(zhí)行就可以了。（注意：操作之前，請先進(jìn)行網(wǎng)站備份）
已經(jīng)是第一篇啦！
