Delete duplicate title using query mysql wordpress

Install wordpress2blogger converter di localhost
December 1, 2012
Delete all post in a category wordpress
December 17, 2012

Delete duplicate title using query mysql wordpress

DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
group by post_title
having count(*) > 1
) as good_rows on good_rows.post_title = bad_rows.post_title
and good_rows.min_id <> bad_rows.id

Comments are closed.