WordPress.org

1. bottleneck
   Member
   Posted 2 years ago #

   Hi, everyone.

   What command should be run in DB to create a file with all blog's tags?

   The latest database description for 2.7 reads "tags for posts are found within the wp_terms table."

   Thanks in advance.

2. MichaelH
   Volunteer
   Posted 2 years ago #

   Using this sql in phpMyAdmin will display those tags.

   SELECT name FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'post_tag'

   You can also export the results of that query in phpMyAdmin if necessary.

3. bottleneck
   Member
   Posted 2 years ago #

   That's just terrific!

   Thanks a lot.

Topic Closed

This topic has been closed to new replies.