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 field | Jason Joines | 24 Jul |
• RE: select part of a field into another field | Dathan Vance Pattishall | 24 Jul |
• Function to extract difference in Minutes from DateTime variables | C.F. Scheidecker Antunes | 24 Jul |
• RE: Function to extract difference in Minutes from DateTime variables | Dathan Vance Pattishall | 24 Jul |
• Re: select part of a field into another field | Mysql List | 24 Jul |
• Re: select part of a field into another field | Victoria Reznichenko | 24 Jul |
• RE: select part of a field into another field | Jonathan Patton | 24 Jul |
• Re: select part of a field into another field | Jason Joines | 24 Jul |
• Re: Function to extract difference in Minutes from DateTime variables | Info | 26 Jul |
• RE: Function to extract difference in Minutes from DateTime variables | Info | 26 Jul |
• Re: select part of a field into another field | Info | 26 Jul |
• Re: select part of a field into another field | Info | 26 Jul |