wordpress删除重复标题文章的方法
使用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;
常见问题FAQ
- 美化包支持最新版本吗?
- 最新美化支持永久更新!
使用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;