francois-blanchard/manage_tags.md

## manage_tags.md

      
    Raw
  

              manage_tags.md
            
          
    Manage tags with SQL wordpress

List tags

SELECT name, slug, description, COUNT FROM wpbandc_terms
NATURAL JOIN wpbandc_term_taxonomy
WHERE taxonomy="post_tag"
ORDER BY name;
Delete tags

DELETE t, tr, tt
FROM wp_terms t  
INNER JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships tr ON tt.term_taxonomy_id = tr.term_taxonomy_id
WHERE tt.taxonomy = 'post_tag'