List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 13 2006 2:02am
Subject:Re: how to extract common text string from field?
View as plain text  
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
Thread
how to extract common text string from field?Ferindo Middleton13 May
  • Re: how to extract common text string from field?Eduardo Galván13 May
  • Re: how to extract common text string from field?Dan Nelson13 May
RE: how to extract common text string from field?Robert DiFalco13 May