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 _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
