MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jason Joines Date:July 24 2003 5:53pm
Subject:select part of a field into another field
View as plain text  
  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
========================
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