2 messages in com.mysql.lists.mysqlRe: Fulltext - stop words!?| From | Sent On | Attachments |
|---|---|---|
| Peter Engström | 09 Jul 2003 10:07 | |
| Keith C. Ivey | 09 Jul 2003 10:26 |
| Subject: | Re: Fulltext - stop words!?![]() |
|---|---|
| From: | Keith C. Ivey (kei...@smokefreedc.org) |
| Date: | 07/09/2003 10:26:18 AM |
| List: | com.mysql.lists.mysql |
On 9 Jul 2003 at 19:07, Peter Engström wrote:
I want to search for an e-mail address but I don't get any matches. I assume characters like @ . are ignored (stop words).
A "stop word" is a *word* that is ignored in indexing -- usually things like "the" and "and". What you're talking about is changing the set of characters that are considered to be parts of words -- usually letters and numbers.
In order to have e-mail addresses indexed as single words, you would have to define every character that could occur in an e-mail address as a word character. In particular, that would mean "." would have to be a word character, and I seriously doubt you would want that. Doing that would mean that searching for "numbers" wouldn't find this message, which contains "numbers." (with a period at the end).
E-mail addresses would normally be searched for as phrases, so "pete...@student.liu.se" would be equivalent to "peten714 student liu se". To search for a phrase you need to use Boolean mode. See the documentation:
http://www.mysql.com/doc/en/Fulltext_Search.html
-- Keith C. Ivey <kei...@smokefreedc.org> Tobacco Documents Online http://tobaccodocuments.org




