select part of a field into another field

[Jason Joines]

 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]