On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivan<[email protected]> 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/[email protected]
