title

WP SQL – Delete all unused post tags

 

WP SQL – Delete all unused post tags

18 Juil 2013, Posted by antoine in

Remember 4 or 5 years ago, tags where very popular in blogging. But now, many bloggers stopped used them. If you did, save some space on your database by cleaning it from unused tags.

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

→ Source: http://4rapiddev.com/tips-and-tricks/wordpress-delete…

NO COMMENT