Nathan,
That was exactly what I was looking for, thanks for your help.
John
-Original Message-
From: Nathan Sullivan [mailto:nsulli...@cappex.com]
Sent: Monday, June 29, 2009 2:55 PM
To: John Furlong; mysql@lists.mysql.com
Subject: RE: Update email address domain
John,
I think this
John,
I think this should work:
UPDATE members SET email=REPLACE(email, SUBSTRING(email,INSTR(email,'@')+1),
'Thanks_in_advance.com.com')
Regards,
Nathan
-Original Message-
From: John Furlong [mailto:john.furl...@rakutenusa.com]
Sent: Monday, June 29, 2009 12:54 PM
To: mysql@lists.my