> I have a column where I need to replace all instances of the text "US-
> Complete" (contained within a long sentence) with "US Complete".
> There are probably 50 or 100 of them. I'm really scared to do it
> since I can't risk screwing up that column - what's the correct syntax?
When you s
Brian Dunning wrote:
I have a column where I need to replace all instances of the text
"US-Complete" (contained within a long sentence) with "US Complete".
There are probably 50 or 100 of them. I'm really scared to do it since I
can't risk screwing up that column - what's the correct syntax?
Brian Dunning wrote:
I have a column where I need to replace all instances of the text
"US-Complete" (contained within a long sentence) with "US Complete".
There are probably 50 or 100 of them. I'm really scared to do it since
I can't risk screwing up that column - what's the correct syntax?
I could use the same thing... just looking through the documentation there
is a replace() function. Maybe do a backup/restore to a test database before
doing this on your live system...
UPDATE `tablename` SET `fieldname`=REPLACE(tablename.fieldname,'US-
Complete','US Complete') WHERE `fieldname` L
