Bob,
Try:
UPDATE pictures set caption = REPLACE(caption,'www.bob.com',www.bubba.com')
WHERE caption like '%www.bob.com%'
Make sure you backup or copy data before trying...
See MySQL Manual 'Language Reference-String Functions'
I hope this helps...
Pat...
CocoNet Corporation
825 SE 47th
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 in
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