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.12 sec)
------------------
select tdate, left(header,125) from archivel where match (header) against
('"president bush"' in boolean mode);
==> 1979 rows in set (2.40 sec)
------------------
select tdate, left(header,125) from archivel where match (header) against
('"president bush" "donald rumsfeld"' in boolean mode);
==> 1979 rows in set (2.39 sec)
------------------
select tdate, left(header,125) from archivel where match (header) against
('+"president bush" +"donald rumsfeld"' in boolean mode);
==> 1979 rows in set (2.39 sec)
------------------
select tdate, left(header,125) from archivel where match (header) against
('+"president bush" +"donald rumsfeld"' in boolean mode);
==> 1979 rows in set (2.39 sec)
------------------
select tdate, left(header,125) from archivel where match (header) against
('("president bush") ("donald rumsfeld")' in boolean mode);
==> 3522 rows in set (2.61 sec)
------------------
select tdate, left(header,125) from archivel where match (header) against
('+("president bush") +("donald rumsfeld")' in boolean mode);
==> 1979 rows in set (2.52 sec)
------------------
select tdate, left(header,125) from archivel where match (header) against
('+("president bush") -("donald rumsfeld")' in boolean mode);
1979 rows in set (2.53 sec)
------------------
select tdate, left(header,125) from archivel where match (header) against
('-("president bush") +("donald rumsfeld")' in boolean mode);
==> 1535 rows in set (2.45 sec)
------------------
Thanks,
Vadim.
Sergei Golubchik wrote:
>
> 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 not
> > allowed, with or without parentheses...
>
> Could you explain, what result is desired and what result you are getting ?
> Because, right now I can only say that multiple ".." elements ARE
> allowed, of course.
>
> > On a general note, it would be nice to have the formal syntax of FT search
> > patterns in the manual.
>
> I do not understand, what is missing in the manual right now ?
> There is a list of operators, you can use any of them in whatever
> combination you want.
>
> Regards,
> Sergei
>
> --
> MySQL Development Team
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
> <___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
