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
>
