What i would like is the search to work exactly like before only that it defaults to AND instead of OR.
Almost every search engine i have tried, google etc. works like this.
"black horse cat dog" only show results with all words present.
This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|'
I really appreciate your help!!
From: Sergei Golubchik <[EMAIL PROTECTED]> To: Jessica Svensson <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
> Is there any way i can get results with AND instead of OR?
> Trying to search for "black cat" should only return records that contains
> both black and cat.
>
> I'm using the following code to get my result:
>
> SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN
> BOOLEAN MODE);
>
> sure there must be an easy way to change the default word separator to AND
> instead of OR?
There is. See ft_boolean_syntax variable - it defines what characters is used for each operator. In particular it defines '+' for "must be present" and a space ' ' for "optionally present" words.
You want to put the space first (for "must be present" words)
Regards, Sergei
-- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com
_________________________________________________________________ Lättare att hitta drömresan med MSN Resor http://www.msn.se/resor/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]