MySql Query to view unique categories in your WordPress database

In Programming Tags #wordpress #mysql Published 2/8/2012

I’m currently in the process of writing ASP.Net controls that look in the WordPress database and render out it’s data in a knowledge base like format. I’m probably be sharing some of the SQL (as well as the controls later) I’m using to read the info.

Here’s the code to view the unique categories that exist in your WordPress tables.

select distinct t.term_id, name, count
    from wp_term_taxonomy tt
inner join wp_terms t on tt.term_id = t.term_id
where taxonomy = 'category'

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.