Can anyone help me understand why
returns exactly the same results asCode:SELECT * FROM `SITES_RANGE` WHERE MATCH ( NAME ) AGAINST ( '+sip +compressors' IN BOOLEAN MODE )
Im using mysql 4.1.Code:SELECT * FROM `SITES_RANGE` WHERE MATCH ( NAME ) AGAINST ( 'sip compressors' )
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?