On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivan<nsulli...@cappex.com> wrote: > Carlos, > > I think this does what you want: (untested though) > > UPDATE identities > SET email=replace(email, 'mail.', '') > WHERE email like '%mail.iamghost.com'
That worked perfect! UPDATE identities -> SET email=replace(email, 'mail.', '') -> WHERE email like '%mail.iamghost.com'; Query OK, 47 rows affected (0.01 sec) Rows matched: 47 Changed: 47 Warnings: 0 mysql> select name, email from identities where email like ('%mail.iamghost.com'); Empty set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org