Re: how to extract common text string from field?

[Dan Nelson]

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
	dnelson@stripped