XF 1.2 sql search and replace

[thiaago13]

I need to change a old site name for another in all posts / topics , please a sql command for this?

 

[AndyB]

To update posts I use this in phpMyAdmin

UPDATE xf_post SET message = REPLACE(message, 'old text', 'new text')

 

[thiaago13]

thanks

and threads?

 

[Paul B]

You only need to update the post table.

 

[cmeinck]

Following up my title post, I'd like to do something similar within posts. However, my concern is that it will also affect URLs that have the same term. For example, if I do this:

UPDATE xf_post SET message = REPLACE(message, 'iphone','iPhone');

Any website with iphone in the URL would change to http://iPhone.apple.com instead of the proper http://iphone.apple.com

Would this second run address specific cases?

UPDATE xf_post SET message = REPLACE(message, 'iPhone.apple','iphone.apple');

I don't want to adversely affect other words with the replace, so using caution and seeking advice. Does it see iPhone.apple as a single term?

 

[AndyB]

Would this second run address specific cases?

Yes

Does it see iPhone.apple as a single term?

Yes