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

代碼如下：

<?php
require(‘./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);
?>

注意：按照以上方法執行，可能會出現菜單不顯示。檢查發現進入wordpress后臺，點擊文章-》分類目錄，重新編輯所有分類目錄，然后去外觀-》菜單，重新編輯菜單即可。