How to Mass Rename Tag?

Question

im switiching from this-tag to "this tag".

i know i can rename tag by editing the post, but thats very time consuming. is there another way? thanks

Answer 1

I'm fairly certain that the database tag format hasn't changed, so what you can do is replace dashes with spaces directly in the database. This query will do it:

    UPDATE qa_posts SET tags=REPLACE(tags, '-', ' ')

Then you must do a full reindex under Admin > Stats, for Q2A to pick up the changes. If you have a lot of posts, this can take many minutes and may cause a few errors on the site while the reindex is happening.

P.S. I'd recommend doing a database backup first in case anything goes wrong.

Comments

But I dont know which file should I modify? is it qa-config.php ? thanks

---

OK, so I made query on phpmyadmin, using this UPDATE qa_posts SET tags=REPLACE(tags, '-', ' ')

.. and the tags are renamed successfully but only on post and main page, while tags on  http://www.site.com/qa/tags remain using hyphen-tags like http://www.question2answer.org/qa/tags

any solution? thanks

UPDATES:
IT WORKS. I forgot to do a full reindex under Admin Stats. Thank you :)

---

Glad it worked! I made that bit bold above in case others want to do the same thing ;)