MySQL search/replace. help please

["t s a d i" <chadee@hotmail.com>]

hello gang!

 i have a column in my table called "pagetext" w/c contains a _lot_ of data 
in it (its the column containing the data for posts made on a message 
board).
 what i need to do is to search out all occurences of the string 
"www.olddomain.com" and change it to "www.mynewdomain.com".

hope someone can help.

thanks in advance,
chadee

PS.  most of the time, "www.olddomain.com" doesnt appear on its own, but as 
"www.olddomain.com/blah/blah.html", i.e., there are other characters beside 
it, and thats whats really confusing me
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.