2 messages in com.mysql.lists.mysqlRe: Fulltext - stop words!?
FromSent OnAttachments
Peter Engström09 Jul 2003 10:07 
Keith C. Ivey09 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