Im using mysql 4.1.
I was hoping that the boolean mode search would only find results with both of the words in the match field. But its returning the same as the simple full text search. What am i doing wrong?

02-06-2013, 02:36 PM

timgolding

After much searching i found the answer.

ft_min_word_len was set to 4 so the term +sip was being ignored as it is under 4 letters.

The solution was

to put
[mysqld]
ft_min_word_len=3

into my.cnf and restart the mysql server then recreate my full text indexes.