WordPress删除重复标题文章的几种方法

网站最近发现好多文章有重复的，手工一个一个很麻烦，就想到了程序。下面就是WordPress删除重复标题文章的几种方法

一、通过操作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(*)