A common problem often encountered is the creation of duplicate posts in WordPress. This usually happens as soon as you start using automation plugins and/or feeds content to your blog via RSS.

This common problem is encountered often, and I released a plugin back in 2009 (still under development) that deletes duplicated posts or pages. Read more on the plugin page WordPress Delete Duplicate Posts or directly at the wordpress.org plugin page.

You can also do it manually via MySQL:

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

Note: Above example is when you have “wp_” as your table name prefix. Also note you really should back up your website before you run this MySQL query. Things can go really wrong if you do not.

The above code is provided by comments from the WordPress Support Forum, as well as from Kieran Barnes – WordPress WP-O-Matic Duplicate Posts Fix.

Finally, I have just sent in an approval for WordPress to host a plugin which will help you do this, by adding another tool to your WordPress arsenal. The plugin will be free of charge. I will make an announcement when the plugin is released.

Read also  Change how the categories are listed for posts

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match