Removing Duplicate Content in WordPress

Although this blog is constrained from blogger platform, but if you happen to read it using the wordpress platform, this might be your lucky day. I wanted to share about how to remove duplicate content / double content / duplicate content / duplicate post from your blog so it does not get angry om Google. Duplicate content problems could be “killer” SEO if we do not care, especially now that many who are promoting AutoBlogged modes. With the increasing number of blog post that many, perhaps hundreds of articles per day, without proper management and proper and intensive, then the blog could be a problem. Ranking in Google can go down.

For that you should be able to control it all. Well, this time we learn how to manage a good wordpress blog by removing duplicate content easily without the plugin. You can use some code that happened to mysql sql to delete the double post. Easy to do, go first to an area hostingmu cPanel. The next step is to go to phpAdmin area.

After that, then select the database name where you want to fix.

After that also, please go to the SQL menu.

Enter the code this SQL syntax:

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;