rermove categories woocommerce sql

Solutions on MaxInterview for rermove categories woocommerce sql by the best coders in the world

showing results for - "rermove categories woocommerce sql"
Greta
24 Jan 2019
1DELETE a,c FROM wp_terms AS a 
2LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
3LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
4WHERE c.taxonomy = 'product_tag';
5
6DELETE a,c FROM wp_terms AS a
7LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
8LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
9WHERE c.taxonomy = 'product_cat'
10