[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

MySQL search/replace. help please

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,

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.

Reply to: