BATCH BULK MASS DELETE REMOVE UNUSED EMPTY TAGS MYSQL PHPMYADMIN WORDPRESS


Run this in your phpMyadmin or anywhere you can execute sql

PHPMYADMIN

DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );

This will effectively remove them from everywhere the admin can see but they still exist in the relationship table

DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);

Remember you need to change the ‘wp_’ to your prefix. Sorry no plugin, perhaps when I have time.

SOLUTION BY portlandparanormal

3 thoughts on “BATCH BULK MASS DELETE REMOVE UNUSED EMPTY TAGS MYSQL PHPMYADMIN WORDPRESS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s