Re: FullText Searches with Email Addresses

[Faury Rodriguez]

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, "[e-mail]" 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')