Ready to get started?Download WordPress


[resolved] Where are stored the "tags" in the database ? (4 posts)

  1. yannick1234
    Posted 6 years ago #


    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 !

  2. Kafkaesqui

    Posted 6 years 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.

  3. Roy
    Posted 6 years ago #

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

  4. yannick1234
    Posted 6 years 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 ;-)


Topic Closed

This topic has been closed to new replies.

About this Topic