Where are stored the “tags” in the database ?

  • Resolved yannick1234

    (@yannick1234)


    16 years, 4 months ago

    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)
  • Kafkaesqui

    (@kafkaesqui)

    16 years, 4 months ago

    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.

    Roy

    (@gangleri)

    16 years, 4 months ago

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

    Thread Starter yannick1234

    (@yannick1234)

    16 years, 4 months ago

    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.