If you've built from source, the stopwords are in
path-to-source/myisam/ft_static.c
In my copy of 4.0.18, beyond is in the list.
You can create your own stopword list, or turn off stopwords altogether, if you want. See <http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html> for the details.
Michael
Richard Baskett wrote:
In my system variables it shown that the stopword file is "(built-in)" so where would I find it then if it is built in.. 'Beyond" does not seem like a word that would be in a built-in stopword file does it? Could it be reserved?
Thanks!
Rick
on 5/6/04 15:30, Dathan Vance Pattishall at [EMAIL PROTECTED] wrote:
Check to see if beyond is in your stopword file.
-----Original Message----- From: Richard Baskett [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:12 PM To: MySQL Subject: Fulltext searching
Ok having some problems with MySQL's fulltext search. I have the fields that I need fulltext indexed, everything seems to be working correctly, but for some reason when I search for "beyond" looking for an item called:
"Beyond Heaven yoga & Day Spa"
It doesnąt find it.. I am searching in boolean mode by the way. but if I search for "heaven" it does find it. I have no idea why it will not find that first word... Actually it finds it when using all the words, except when I use "beyond"
Now it just occurred to me.. if there is only one result.. will it not show that there was a result? Or is it something completely different?
Thanks!
Rick
"What lies behind us and what lies before us are tiny matters compared to what lies within us." - Oliver Wendell Holmes
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
