How can I write full search index query which will not consider any stopwords?


Problem :

I have written a query which will perform Full Text search using full search Index in mysql Table.

But my problem is that when user searches with "to go" then it will not search anything because of stopwords in mysql.

So my question is, how can I write a Full Search query which will ignore the stopwords?



Solution :

To override the default stopword list, set the ft_stopword_file system variable. (See Section 5.1.4, “Server System Variables”.) The variable value should be the path name of the file containing the stopword list, or the empty string to disable stopword filtering. The server looks for the file in the data directory unless an absolute path name is given to specify a different directory. After changing the value of this variable or the contents of the stopword file, restart the server and rebuild your FULLTEXT indexes.

http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html


Mysql Tutorials

Mysql Howto..

MYSQL: How Do I Show Sort Table from Last to First?

How to search in table of multiple parameters in MySQL?

How to Bring an active anchor tag color in dynamic while loop?using php and mysql

how to insert a record into mysql(jdbc) in java using rmi? [closed]

How to correctly check database connection with mysql in a .NET application?

how to search for multiple full and partial values in MySQL?

How to merge 2 Records in innoDB MySQL databases

How to query several similar databases using Peewee?

PHP Function : how do send value to html

How to select a random row in MySQL and PHP? [duplicate]

In MySQL how to write SQL from two tables?

how to config wamp2's mysql server?

How to append a value to an existing column in mysql which can contain null or a String?

How do I restore only 1 mySQL value row for an entire table?

How to create a JDO DataNucleus key string field of unknown size?

How to display a mysql query

How to query for err in MySQL?

Found a weak escape function for MySql, how to exploit?

How to get row numbers from MySQL table?

How to display json object stored in MySQL with AngularJS

How to Delete a record from the DataBase mysql &Screen while Clicked on ListView item?

How to aggregate results from many rows into a single row mysql [duplicate]

How to create table of tables c# my sql

how to use sum, multiply, divide and group by aggregation in single mongodb query

How do I insert a date into mysql as a parameter?

how do foreign key works in MYSQL?

how to create procedure in mysql for selecting record?

How to Carry forward a column value while inserting other column values in mysql?

How to perform a case sensitive search on a case insensitive MySQL database?

How to update timestamp in a mysql database?