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 "[EMAIL PROTECTED]" 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 <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
