WordPress – query to dump all categories

on

WordPress mysql query to dump all categories (id, slug, name, description, count)

SELECT wp_terms.term_id, wp_terms.slug, wp_terms.name,
  wp_term_taxonomy.description, wp_term_taxonomy.count
FROM wp_term_taxonomy join wp_terms
  on (wp_term_taxonomy.term_id = wp_terms.term_id)
WHERE wp_term_taxonomy.taxonomy = 'category'

Suggested posts:

  1. Command line – scale a video using ffmpeg
  2. WordPress – query to find term_taxonomy_id from tag name
  3. WordPress – an approach to bulk add tags to posts
  4. Apache – how to remove php extension from url
  5. Chrome – view javascript errors
  6. Curl – follow redirects
  7. Mac – search files on command line using mdfind
  8. PHP check if key exists in array
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged , ,