View Single Post
Old 07-16-2004, 02:44 PM  
Due
Confirmed User
 
Due's Avatar
 
Industry Role:
Join Date: Mar 2001
Location: Murrieta, CA
Posts: 3,620
Quote:
Originally posted by M_M
UPDATE tablename SET fieldname = REPLACE(fieldname,'domainA','domainB')


u gotta study more my man
Well I just posted a search and replace script I made a few months ago.
Got nothing to do with if I need to study more or not.
The original search and replace script contained a lot more functions that included updating other tables for some of the results depending on what was returned from the first result.
So a simple replace wouldn't be good enough for what I needed it for.
__________________
I buy plugs
Skype: Due_Global
/Due
Due is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote