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
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
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.*Now Just wait for about 2 minutes and All your Duplicate Posts will be removed magically
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
No comments:
Post a Comment