Replace old URL with new URL from entire Database

[David_R]

thankyou very much for posting the easy solution here.
some questions.

Text to be replaced was our olddomain name, it used extensively across the database. In code tags, html tags, php tags, signatures, posts, pms, notes, every possible end-user area,

As suggested by you.

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

This will replace www.olddomain.com with www.newdomain.com ?

To execute other replacements:
olddomain.com
www.olddomain.com/forum
forum.olddomain.com
I assume I will only need to run 1 additional line:

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

?