how can i disable the stopword in mysql php

how can i disable the stopword in mysql
i am using the select match command using php and i want mysql to index all the word includeing the common words like old,new,and,or......
so how can i do this thanks
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:

This variable cannot be set dynamically.. i.e using SET GLOBAL ft_stopword_file =<somevalue>
Name                  Cmd-Line       Option file       System Var       Var Scope       Dynamic
ft_stopword_file       Yes          Yes                Yes                 Global                No

This can be set thru commandline(while starting mysqld), thru optional file(my.cnf/my.ini)

The file from which to read the list of stopwords for full-text searches. All the words from the file are used; comments are not honored. By default, a built-in list of stopwords is used (as defined in the myisam/ft_static.c file). Setting this variable to the empty string ('') disables stopword filtering.

As given in above comment...pls place this in my.cnf/my.ini(if windows)


Also, do remember


FULLTEXT indexes must be rebuilt after changing this variable or the contents of the stopword file. Use REPAIR TABLE tbl_name QUICK.
You need access to MySQL files.

I believe in my.cnf (mysqls config file) there is a variable called ft_stopword_file.

You can disable stopwords by setting the variable ft_stopword_file to an empty string and restarting.

if it is not there, you can login and check in mysql command based promt. Basicly get into a mysql prompt:

mysql -uroot -pPasshere

After you are logged in to mysql, you can type:

SET Global ft_stopword_file=

\g is for GO, basicly. If it finds it, it should null it. Hopefully that will work if the first step doesnt
All Courses

From novice to tech pro — start learning today.