-----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 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 field?
Thanks,
Jason Joines Open Source = Open Mind ========================
Jonathan Patton wrote:
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) | +-------------------------------+ | test | +-------------------------------+ 1 row in set (0.00 sec)
There are probably other ways to do this as well.
Jonathan
Thanks, that was exactly what I needed! Until all the responses to my message it never occured to me to search the manual for string fucntions.
Jason ============
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]