...

View Full Version : In boolean mode



timgolding
02-06-2013, 12:23 PM
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
02-06-2013, 02:36 PM
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum