MySQL search/replace. help please
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
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,
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