Forum Moderators: coopster

Message Too Old, No Replies

Need To Change MySQL Stop Words List

mysql stop words stopwords

         

matthewamzn

6:02 pm on Aug 31, 2005 (gmt 0)

10+ Year Member



How do I change the mysql stopwords list? Is there a way to do it through phpmyadmin or could I use a gui like Navicat?

zCat

6:46 pm on Aug 31, 2005 (gmt 0)

10+ Year Member



This is only possible with MySQL 4.0.10 or later, and if you have some kind of admin access to the server. See:

[dev.mysql.com...]

from the section beginning with " To override the default stopword list, ... "

(Prior to this version changing the stopword list entailed recompiling the server.)

jatar_k

6:47 pm on Aug 31, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I am wondering, why would you want to?

matthewamzn

5:21 am on Sep 1, 2005 (gmt 0)

10+ Year Member



Some of the words my visitors search are contained in the stopwords list ('after', 'zero' ect). When they search for these keywords the query cancels.