In boolean mode

[timgolding]

Can anyone help me understand why

SELECT *
FROM `SITES_RANGE`
WHERE MATCH (
NAME
)
AGAINST (
'+sip +compressors'
IN BOOLEAN
MODE
)

returns exactly the same results as

SELECT *
FROM `SITES_RANGE`
WHERE MATCH (
NAME
)
AGAINST (
'sip compressors'
)

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?

[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.