>> 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. =AGAINST (<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.search#"> IN BOOLEAN MODE) I *still* get "Harry Potter" in the results! 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! Hmmmmmmmmm............ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287597 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4