How to delete empty tags in wordpress without any plugin

In this blog; most of the articles have been tagged with some of the keywords. And I have deleted hundreds of posts on this blog, so when I delete an article the tag associated with that article is not deleted. If a tag is associated with only one post then if that article is deleted the tag will be in database as an empty tag. After deleting hundreds of posts there were hundreds of empty tags in my blog.

empty tags in phpmyadmin

To delete these empty tags there are a few ways.

(1) Delete empty tags manually

Go to WP-admin>>Posts>>Tags
Look for tags tagged with zero (0) posts and delete them manually. But this process is not good for practical uses. You will search for empty tags and delete each empty tag manually.

(2) Using a plugin

You can search any good plugin that will filter empty tags and you can delete them. But it will increase your database size. You can try plugin here.

(3) Delete empty tags in phpMyAdmin

For new users it is a careful step but very effective for future uses.
>> Go to cPanel (in your hosting account)
>> In database section click on phpMyAdmin
>> In phpMyadmin login with username and password
>> Select the database, if you have one blog then you will have only one database.
>> Click on wp_term_taxonomy table (wordpress database has some tables)
>> click on search tab (search tab is in second navigation on top)
>> In search section there are 5 columns and 6 rows. So in the last row of last column or in the value column enter zero “0”. Then click on go.
>> It will return all the empty tags and categories; you can check all and delete them.

I have prepared a video.

Related Posts:

previous post: Did you know you can open online saving bank account in India?
next post: Looking for funds to start your project? Here you go

4 thoughts on “How to delete empty tags in wordpress without any plugin

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>