never mind, solved the issue 🙂
can u plz tell me how u solve this problem…………i have tons of duplicate post in my blog.total 10000 post where minimum 2000 duplicate…………..plz help me
Try this one – it’s free.
you can run this SQL QUERY on your MySQL admin panel (such as phpMyAdmin) -> faster and safer – don’t forget to back up your DB in case anything goes wrong -> assuming that your WP tables are called wp_ (if it is something different all you have to do is replace that part on the query for the proper tables name)
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
