[mysql] fulltext search problem

[Michael Southwell]

Rob Marscher wrote:

> You probably got it by now... but you need the "IN BOOLEAN MODE" modifier:

hmm, I found the docs confusing. IN NATURAL LANGUAGE MODE is the default 
and it seemed as though all BOOLEAN does is allow the + and - operators. 
But a closer reading now reveals that this default observes the 50% rule 
(ignoring any result if the word occurs in > 50% of the rows, 
essentially turning it into a stop word), whereas BOOLEAN does not. I'm 
guessing that that is the real reason that this failed with my small 
test data.

Anyway, the big thing is that now it is working. Many thanks!


-- 
=================
Michael Southwell
Vice President, Education
NYPHP TRAINING:  http://nyphp.com/Training/Indepth