Forum Replies Created

Viewing 1 replies (of 1 total)
  • 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 1 replies (of 1 total)