http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html =]
On 9/1/07, Les Mizzell <[EMAIL PROTECTED]> wrote: > Working Query (finally!) > > SELECT title, > Author, > Publishers, > ListPrice, > ISBN > FROM booksDATA > WHERE MATCH (Title, Author, Publishers) > AGAINST (<cfqueryparam > cfsqltype="cf_sql_varchar" > value="#form.search#">) > > > If I enter "rabbit potter" (obviously without the quotes) into my search > field, I would expect to see all the "Peter Rabbit" books by Beatrix > Potter, among others. But, I *don't* expect to see "Harry Potter" in the > results, but he's there. > > I thought the query had to return results that contained all of the > words entered into the search, not either/or ... > > So, how do I be sure the results contain BOTH "potter" and "rabbit", > thusly eliminating "Harry Potter"? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:287594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
