> 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?
7;) WHERE `fieldname` LIKE '%US- Complete%';
-Original Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 5 September 2007 10:42 AM
To: mysql@lists.mysql.com
Subject: Editing fields in bulk
I have a column where I need to replace all instances of the t
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?
--
MySQL General Ma
