Hi , you can. see this : mysql> select * from emails; +-------------------+ | t | +-------------------+ | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | +-------------------+ 3 rows in set (0.00 sec)
mysql> update emails set t=concat(substring_index(t,'@',1),'mydomain.com'); Query OK, 3 rows affected (0.05 sec) Rows matched: 3 Changed: 3 Warnings: 0 mysql> select * from emails; +-------------------+ | t | +-------------------+ | name1mydomain.com | | name1mydomain.com | | name1mydomain.com | +-------------------+ 3 rows in set (0.00 sec) Mathias Selon shaun thornburgh <[EMAIL PROTECTED]>: > Hi, > > Is it possible to update all the domain names for an email column? I want to > change everyones email address to my domain for a test site, so can I change > the email address column such that everything after @ is changed to > mydomain.com? > > Thanks for your advice > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
