Sergei, here:
RH7.2/2.4.9-31/Dual P-III 866MHz/MySQL4.0.2
A snapshot from a live database, sorry, couldn't prepare a more detailed
example:
--
select tdate, left(header,125) from archivel where match (header) against
('"donald rumsfeld"' in boolean mode);
==> 188 rows in set (0.
Hi!
On May 06, Vadim P. wrote:
> Hi,
>
> It's not quite clear from the manual, but it appears that queries with
> FULLTEXT search patterns like this:
>
> MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
>
> don't produce the result desired, that is, multiple ".." elements are
2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: Re: FULLTEXT search pattern syntax
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN
MODE)
...
>
"Vadim P." w
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN
MODE)
...
>
"Vadim P." wrote:
>
> Hi,
>
> It's not quite clear from the manual, but it appears that queries with
> FULLTEXT search patterns like this:
>
> MATCH