Before applying my own file I run the following query:
Expand|Select|Wrap|Line Numbers
- Select title from table where MATCH (title) AGAINST ('+The +Confession' IN BOOLEAN MODE)
- title = The confession
- title = confession
I have verified "the" is in my stopword file and should also be considered a default stop word.
What I have done so far:
- Created stopword.txt
- Populated stopwords.txt with default stop words (taken from http://dev.mysql.com/tech-resources/articles/full-text-revealed.html).
- added: ft_stopword_file = /etc/stopwords.txt to my.cnf
- Restarted mysql
- Restarted tomcat (just to be sure)
- On mysql command line: show variables like 'ft_%' and I see variable set correctly
Any ideas why the above query is returning no results when i use the ft_stopword_file variable?
Thanks.