Hi all!
I would like to update many records in a table called pictures where I
find a string in the caption column. If the string (e.g. www.bob.com)
is found, replace it with another string (e.g. www.bubba.com).
Unfortunately, there is other text in the caption column of these records,
so I
Terrace
Cape Coral, FL 33904
(239) 540-2626 Voice
- Original Message -
From: Bob Loeffler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 6:01 PM
Subject: Replacing text using the Update command?
Hi all!
I would like to update many records in a table called
Hello Bob,
- Original Message -
From: Bob Loeffler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 10:01 AM
Subject: Replacing text using the Update command?
Hi all!
I would like to update many records in a table called pictures where I
find a string
Pat's version was better than mine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Awesome! It worked perfectly! Thanks Pat and Stephen.
Bob
-Original Message-
From: Patrick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 4:20 PM
To: Bob Loeffler; [EMAIL PROTECTED]
Subject: Re: Replacing text using the Update command?
Bob,
Try:
UPDATE pictures set