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?
select SUBSTRING(email, 1, INSTR(email, '@') - 1) from mytable limit 10000,10;
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]