MySQL Forums
Forum List  »  Newbie

Re: regex in query to cover several possible variations of a gmail username
Posted by: Chad Bourque
Date: November 21, 2010 09:11PM

Well then, like I said, just use the replace function on both sides:

select *
  from tblName
  where replace(email, '.', '') = replace(theSearchValue, '.', '');

HTH,
Chad
Milamade, LLC - Custom Software Development

Options: ReplyQuote


Subject
Written By
Posted
Re: regex in query to cover several possible variations of a gmail username
November 21, 2010 09:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.