Remove Duplicate Posts from WordPress Quickly

Is your WordPress Blog Having Duplicate Contents ? Okay, Dont worry, Actually duplicate contents has been a major issue with auto blogs and RSS feed catchers. Duplicate Contents also happens if you are importing your blogger blog again and again or if you are importing wordpress export file again and again. There are several wordpress plugins to delete duplicate posts from wordpress blog database but some of those plugins do not work and some of them are not free. Here is a free way to remove duplicate posts from wordpress easily. Just follow below given steps to Delete wordpress posts that are posted twice, thrice or more

 

Step#1
Login in Your Hosting Control Panel and Click on myPhpadmin

Step#2
After Clicking on myPhpadmin, you will see a screen like below shown picture.

 

Step#3

Select your Blog’s mySQL database Account, (You will see a list of tables within that database)
Now Click on SQL (it can be located at next tab of structure). After Clicking on SQL, you will see a related image as shown below.

Copy-past below given SQL command and click on Go

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

Now Just wait for about 2 minutes and All your Duplicate Posts will be removed magically

Related Posts