select-terms-query.sql

# For posts categories
SELECT t.term_id AS id,
       t.name    AS 'Term Title',
       t.slug    AS 'Slug'
FROM   wp_terms t
       LEFT JOIN wp_term_taxonomy tt
              ON t.term_id = tt.term_id
WHERE  tt.taxonomy = 'category'
ORDER  BY name;

# For posts tags
SELECT t.term_id AS id,
       t.name    AS 'Term Title',
       t.slug    AS 'Slug'
FROM   wp_terms t
       LEFT JOIN wp_term_taxonomy tt
              ON t.term_id = tt.term_id
WHERE  tt.taxonomy = 'post_tag'
ORDER  BY name;

# For WooCommerce product categories
SELECT t.term_id AS id,
       t.name    AS 'Term Title',
       t.slug    AS 'Slug'
FROM   wp_terms t
       LEFT JOIN wp_term_taxonomy tt
              ON t.term_id = tt.term_id
WHERE  tt.taxonomy = 'product_cat'
ORDER  BY name;

# For WooCommerce product tags
SELECT t.term_id AS id,
       t.name    AS 'Term Title',
       t.slug    AS 'Slug'
FROM   wp_terms t
       LEFT JOIN wp_term_taxonomy tt
              ON t.term_id = tt.term_id
WHERE  tt.taxonomy = 'product_tag'
ORDER  BY name;