wordpress 刪除重複文章

1
2
3
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;