Support » Fixing WordPress » Collecting all tags in one txt file
7 years, 5 months ago
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.
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.
That’s just terrific!
Thanks a lot.