[resolved] Collecting all tags in one txt file (3 posts)

  1. bottleneck
    Posted 6 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
    Posted 6 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
    Posted 6 years ago #

    That's just terrific!

    Thanks a lot.

Topic Closed

This topic has been closed to new replies.

About this Topic