Replace text in all posts....like Replacing Phrases

[Jordan17]

I have just changed the name of my forum, and also the domain to it, I want to change all of the text in posts to the new name.

You may think its pointless, but people have got links all over the place that wont work anymore.

Is there any way I can do this by replacing, like when you search for text in phrases and replace it?

[SaN-DeeP]

to replace text in posts.

UPDATE post SET pagetext = REPLACE(pagetext,'www.olddomain.com','www.newdomain.com')

replace text in pms.

UPDATE pmtext SET message = REPLACE(message,'www.olddomain.com','www.newdomain.com')

to replace text in signatures.

UPDATE usertextfield SET signature = REPLACE(signature,'www.olddomain.com','www.newdomain.com')

you can acheive what you want from above queries

[majorxp]

Thanks...this is exactly what I was looking for.

I also ran this too:

PHP Code:

UPDATE smilie SET smiliepath = REPLACE(smiliepath, 'olddomain.com', 'newdomain.com')