Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Jason Joines [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 1:53 PM
To: MySQL Users
Subject: select part of a field into another field
I have a table with an email field that contains values of the form
[EMAIL PROTECTED] I need to populate a new field
Jason Joines <[EMAIL PROTECTED]> wrote:
> I have a table with an email field that contains values of the form
> [EMAIL PROTECTED] I need to populate a new field called uid with just the uid
> part of the email address. Is there any way of using select to just
> retrieve the part before the @
Jason Joines wrote:
I have a table with an email field that contains values of the form
[EMAIL PROTECTED] I need to populate a new field called uid with just the
uid part of the email address. Is there any way of using select to
just retrieve the part before the @ and insert it into the uid
Its easier to do it code in my opinion but here is the function you will
need.
SUBSTRING_INDEX('[EMAIL PROTECTED]','@',1) --> joines
-->-Original Message-
-->From: Jason Joines [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 10:53 AM
-->To: MySQL Users
-->Subject: select part o
Jason,
For example, if you had a table named "test" with a column named "a", which contained
one row "[EMAIL PROTECTED]" you would do a query like:
mysql> select substring(a,1,instr(a,'@')-1) from test;
+---+
| substring(a,1,instr(a,'@')-1) |
+--
