Support » Fixing WordPress » Where are stored the “tags” in the database ?

  • Resolved yannick1234

    (@yannick1234)


    Hi,

    I would like to upgrade the tags for my posts. Yet, since I have many of them, I wish to avoid doing it manually 🙂

    Hence I’d like to know where are stored the tags of a post in the database, so that I can modify them directly with some SQL tricks.

    Thanks a lot !
    Yannick

Viewing 3 replies - 1 through 3 (of 3 total)
  • They are stored in the (wp_)terms table. Note you may also be interested in the terms_taxonomy table, where tags are defined as such (under the taxonomy column as ‘post_tag’). Real cool SQL tricks may require joining these two tables together to delimit tags from other references such as categories in the terms table.

    Maybe you have enough with this great plugin until this feature is available in WP standard.

    Thanks guys for the answers,

    I’ve just installed the plug-in, it’s so great !
    Finally, I will probably use it rather than SQL 😉

    Regards,
    Yannick

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Where are stored the “tags” in the database ?’ is closed to new replies.