WordPress.org

1. lynn.currie
   Member
   Posted 3 years ago #

   Hi All,

   Is there a way (a plug-in perhaps?) to delete unused tags en mass?

   Thanks,

   Lynn

2. MortenBlaabjerg
   Member
   Posted 3 years ago #

   I have the same query - any ideas?

3. Eckhard
   Member
   Posted 3 years ago #

   How to ban words from being tagged

   for example, me, you, your, the, a,b ,c, .......?
   some entries got 50 tags and just junk

4. peps974
   Member
   Posted 2 years ago #

   Hey guys,
   any of you have found a way to bulk delete unused tags?

5. portlandparanormal
   Member
   Posted 2 years ago #

   Run this in your phpMyadmin or anywhere you can execute sql

   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.

   I had to use this to remove over 2,000 unused tags on my home site Portland Paranormal

Topic Closed

This topic has been closed to new replies.