UPDATE mytable SET email = CONCAT(LEFT(email,LENGTH(email) - 4),".ca")
WHERE RIGHT(email,8) = "test.com";
Something like that?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Grant Cooper [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 2:39 PM
To: [EMAIL PROTECTED]
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
