From: Jason Joines Date: July 24 2003 8:30pm Subject: Re: select part of a field into another field List-Archive: http://lists.mysql.com/mysql/146065 Message-Id: <3F2041EB.2070901@bus.okstate.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit > > >>-----Original Message----- >>From: Jason Joines [mailto:joines@stripped] >>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 >>uid@domain. 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 "test@stripped" 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 ============