John thegimper wrote:
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
G
efaults 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 = ' +-><()~*:""&|'
&
7;
>
> I really appreciate your help!!
>
> >From: Sergei Golubchik <[EMAIL PROTECTED]>
> >To: Jessica Svensson <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: Please help me: Boolean fulltext searches, AND instead of
> OR
> >Date: Wed,
>
> 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@list
t 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.mys
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 (tex
I couldn't find much on the variable you were trying to change.
Although it may have changed and now be called ft_boolean_syntax. But
that still won't help you since it doesn't appear to have an option to
change the default separator.
I think you will need to add the + to each word if you want t
