Check the string functions SUBSTRING and LOCATE. As a hint look for the
position of '@'.
Ferindo Middleton escribió:
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.
Ferindo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
