Patrick J Okui wrote:
>I have two collumns in my mysql database like this
>
>+------------------+------------+
>|id |domain |
>+------------------+------------+
>|user@domain1com |domain1.com |
>|[EMAIL PROTECTED] |domain1.com |
>|[EMAIL PROTECTED] |domain1.com |
>+------------------+------------+
>
>in a table users.
>
>How do I construct an sql update statement like
>update users set id =..... where domain = "domain1.com"
>
>so that the id column becomes
>+------------------+
>|id |
>+------------------+
>|[EMAIL PROTECTED] |
>|[EMAIL PROTECTED] |
>|[EMAIL PROTECTED] |
>+------------------+
>
>
How about:
UPDATE <table> SET id = concat(left(id, locate(id, '@')), 'domain2.com')
WHERE domain = "domain1.com";
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
