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 > -----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 > ======================== > > > > -- > 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]
