Delete unused tags in bulk

Viewing 4 replies - 1 through 4 (of 4 total)

  • I have the same query – any ideas?

    How to ban words from being tagged

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

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

    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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Delete unused tags in bulk’ is closed to new replies.