WordPress.org

1. Mayur Somani
   Member
   Posted 3 years ago #

   Is there any plugin that can be used to remove duplicate posts from my wordpress 2.7 blog?

   Thank you for your time.

2. Mayur Somani
   Member
   Posted 3 years ago #

   never mind, solved the issue :)

3. ddlblogdotcom
   Member
   Posted 2 years ago #

   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

4. c. bavota
   Member
   Posted 2 years ago #

   http://bavotasan.com/downloads/delete-duplicate-posts-wordpress-plugin/

5. Boris_yo
   Member
   Posted 2 years ago #

   Try this one - it's free.

6. pf69.com
   Member
   Posted 2 years ago #

   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

Topic Closed

This topic has been closed to new replies.