On the surface, WordPress is a Content Management System, but dig a little deeper and you find out that it supports a vast ecosystem. This vast ecosystem is built on thousands of themes, plugins, community-users, etc. As all the elements of this ecosystem come together, they create a user-experience unparalleled by any other Content Management System on the market.

This ecosystem has also resulted in the creation of a Content Management System that is so easy to use, it even attracts complete newbies. It is this ease of use that empowers people with the most basic knowledge of website designing to build on their dreams and turn it into reality. 

The prime example of the above statement is the rise in the number of people who pursue their niche blogging ideas on the internet. With the rise in the number of people blogging with WordPress, the problems encountered have also increased. For example, the problem of unidentified tags after a blog post has been manually deleted. In the long run, these unidentified tags can pose a maintained nightmare for the website owner/developer. 

How To Identify Unused tag?

Therefore to help you in identifying these tags we bring to you a simple hack that you can learn in no time. To save your website from crashing due to excessive unidentified tags, we need to identify them. The following steps detail hack how you can identify these tags from your MySQL database.  

Step 1 – Run the below SQL query to identify these unused tags:     

SELECT * From wp_terms wt

INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0;

Step 2 – Delete the unnecessary tags to save operational space.