Its easier to do it code in my opinion but here is the function you will
need.
SUBSTRING_INDEX('[EMAIL PROTECTED]','@',1) --> joines
-->-----Original Message-----
-->From: Jason Joines [mailto:[EMAIL PROTECTED]
-->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
-->[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]
