On Aug 4, 2008, at 1:46 PM, Michael Southwell wrote:
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.
Yeah... I think you're right on that. FYI, if you get really
frustrated with the MySQL fulltext searching, check out http://www.sphinxsearch.com/
. The latest version is pretty awesome. It does require compiling an
extra server app and using a php api to talk to it. You create a
config file which tells it how to grab the data for your indexes from
MySQL. Then you periodically run a command to update the index. You
won't believe how fast and more contextually relevant it is compared
to the MyISAM Fulltext index though...
_______________________________________________
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
