On 9/1/07, Les Mizzell wrote: > > >> So, how do I be sure the results contain BOTH "potter" and "rabbit", > >> thusly eliminating "Harry Potter"? > > > > http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html =] > > I tried that already.
With the pluses and everything? But, the results are sorted in order of relevance by default, and Harry > is pretty far down the list. Still, I don't understand why it shows up > at all! >From that page: They do not automatically sort rows in order of decreasing relevance. You can see this from the preceding query result: The row with the highest relevance is the one that contains "MySQL" twice, but it is listed last, not first. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
