Quote:
Originally posted by Due
Actually there is.
Else "y/gallery/whatever/213423.html" will just be replaced with "x" when it should have been "x/gallery/whatever/213423.html"
I asume he have 100's or 1000's of galleries saved on 1 domain that need to be updated to be on another domain.
|
UPDATE tablename SET fieldname = REPLACE(fieldname,'domainA','domainB')
u gotta study more my man