Delete unused tags from wordpress site

Tags are used for search engine optimization. We create tags for post but it may be unused. So we should delete unused tags forum our database to save some database space. You can delete this unused tags form WordPress tags sections. But it will take many time to delete. If you want you can do it in second by adding some MySQL query in your database. Before doing this you should backup your database. After backing up your database add the following codes in your SQL options and click on Go Button. Like the below image.

DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );
DELETE FROM wp_term_taxonomy WHERE term_id not IN (SELECT term_id FROM wp_terms);
DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);
database, Delete Unused Tags, how to mysql, MySQL, remove all tages, sql, theme development, WordPress, wordpress database, WordPress mysql,
  • Remove junk from WordPress head without plugin
  • Removing Dashboard Widgets According to User Role

Source: http://4rapiddev.com

Tags: database, Delete Unused Tags, how to mysql, MySQL, remove all tags, sql, theme development, WordPress, wordpress database, WordPress mysql,

Admin

About Admin

Hi I am Md. Masum Billah Contributor of this website. I always like to share various things with other. In this website I am sharing web design related tips and tricks, necessary web development tools, source codes for beginner and advance web developer. You may join with us to help other who want to learn web design and development. Thank you for stay with.

Follow On: Twitter


Leave a Reply

Your email address will not be published. Required fields are marked *