wp删除重复文章的方法

1、使用插件Delete Duplicate Posts

2、使用mysql管理工具执行下面的sql语句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;

3、写一个PHP文件，取名delete.php。上传至网站根目录，打开浏览器运行http://www.域名/delete.php代码如下：<?phprequire(‘./wp-造婷用痃load.php’);$strsql = “create table my_tmp as select min(ID) as col1 from wp_posts group by post_title”;$strsql1 = “delete from wp_posts where ID not in (select col1 from my_tmp)”;$strsql2 = “drop table my_tmp”;$result = mysql_query($strsql);$result = mysql_query($strsql1);$result = mysql_query($strsql2);?>