On 01-Jun-2003 Grant Cooper wrote:
> I'm trying to update an email field. Our company has changed from a .com
> to
> a .ca. I wrote a php script to make the changes but I was wondering if I
> could do this from the command line. Its a text field and I would like to
> replace. [EMAIL PROTECTED] to [EMAIL PROTECTED] Can someone help me out please.
>
> Thank You
>
UPDATE datable SET email=REPLACE(email, '@test.com', '@test.ca')
WHERE email LIKE '[EMAIL PROTECTED]';
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
