In the last episode (May 12), Ferindo Middleton said: > Suppose you have a field in a db table that holds email addresses and all of > the address end in domain.com. Is there a MySQL function that can be used to > extract the first part of the email address, the username (the part of the > email address before the 'domain.com' part of the email address). > > I was hoping somehow to do this within a SELECT statement so instead of > seeing the email address I would see the username without the 'domain.com' > part.
SUBSTRING_INDEX http://dev.mysql.com/doc/refman/5.0/en/string-functions.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]