Similar Tag Solution

  • nickaster

    (@nickaster)


    15 years, 5 months ago

    Let’s say I have a load of posts about Wal Mart. Some are tagged “Walmart” some “Wal-Mart” …. I’d rather not have two tag pages. Is there an easy way to find/replace all these? or better yet, make what would be two tag pages more smartly combine into one?

Viewing 2 replies - 1 through 2 (of 2 total)
  • vtxyzzy

    (@vtxyzzy)

    15 years, 5 months ago

    First, back up your database.

    Assume the term_taxonomy_id (NOT term_id) for ‘Walmart’ is 22 and for ‘Wal-Mart’ it is 66. If you want all posts to be assigned to ‘Wal-Mart’, use this SQL:

    UPDATE IGNORE wp_term_relationships
SET term_taxonomy_id = 66
WHERE term_taxonomy_id = 22

    You can then use WP Admin to delete tag ‘Walmart’.

    Thread Starter nickaster

    (@nickaster)

    15 years, 5 months ago

    Ah ha! nice one. thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Similar Tag Solution’ is closed to new replies.