with '@' added to the second param :
update emails set t=concat(substring_index(t,'@',1),'@mydomain.com');
:o)
Selon [EMAIL PROTECTED]:
> Hi ,
> you can. see this :
> mysql> select * from emails;
> +---+
> | t |
> +---+
> | [EMAIL PROTECTED] |
> |
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),'mydom
shaun thornburgh wrote:
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?
- see REPLACE here:
http://dev.mysq
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
F