MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Dathan Vance Pattishall Date:July 24 2003 6:18pm
Subject:RE: select part of a field into another field
View as plain text  
Its easier to do it code in my opinion but here is the function you will
need.

SUBSTRING_INDEX('joines@stripped','@',1) --> joines

-->-----Original Message-----
-->From: Jason Joines [mailto:joines@stripped]
-->Sent: Thursday, July 24, 2003 10:53 AM
-->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
-->========================
-->
-->
-->
-->--
-->MySQL General Mailing List
-->For list archives: http://lists.mysql.com/mysql
-->To unsubscribe:
-->http://lists.mysql.com/mysql?unsub=1



Thread
select part of a field into another fieldJason Joines24 Jul
  • RE: select part of a field into another fieldDathan Vance Pattishall24 Jul
    • Function to extract difference in Minutes from DateTime variablesC.F. Scheidecker Antunes24 Jul
      • RE: Function to extract difference in Minutes from DateTime variablesDathan Vance Pattishall24 Jul
  • Re: select part of a field into another fieldMysql List24 Jul
  • Re: select part of a field into another fieldVictoria Reznichenko24 Jul
RE: select part of a field into another fieldJonathan Patton24 Jul
  • Re: select part of a field into another fieldJason Joines24 Jul
Re: Function to extract difference in Minutes from DateTime variablesInfo26 Jul
RE: Function to extract difference in Minutes from DateTime variablesInfo26 Jul
Re: select part of a field into another fieldInfo26 Jul
Re: select part of a field into another fieldInfo26 Jul