MySQL Forums
Forum List  »  Full-Text Search

Re: FullText Searches with Email Addresses
Posted by: Faury Rodriguez
Date: June 09, 2008 10:39AM

Just to confirm, person and email are separate fulltext indices?
If not, you would need to include all the fields that are part of the fulltext index in match() otherwise it will do a full table scan.

In regards to your first query, I believe the + operator only works in BOOLEAN mode.

Also, the default characters considered true word chars and thus indexed are just alphanumeric characters, underscores, and a single apostrophe per word. So the search term, "+firstname.lastname@hotmail.com" is really interpreted as "+firstname lastname hotmail com".

If you are going to do just an email lookup, where the full email will be used to looking something up, I would just index it with a BTREE and use LIKE. A common way to do domain lookups, in addition to full email lookups, is to store the reversed email string. So that you could do something like: email LIKE reverse('%hotmail.com')

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: FullText Searches with Email Addresses
3852
June 09, 2008 10:39AM


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.