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. 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 someone confirm, please?
On a general note, it would be nice to have the formal syntax of FT search
patterns in the manual.
TIA,
Vadim.
[sql query - to satisfy the darn spam filter]
-
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
-
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
RE: FULLTEXT search pattern syntax
Hi..
Rewrite it as:
WHERE MATCH (some_text_field) AGAINST ('red pepper' IN BOOLEAN MODE) AND
MATCH (some_text_field) AGAINST (green bean' IN BOOLEAN MODE);
Gurhan
-Original Message-
From: Vadim P. [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 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. 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 someone confirm, please?
On a general note, it would be nice to have the formal syntax of FT search
patterns in the manual.
TIA,
Vadim.
[sql query - to satisfy the darn spam filter]
-
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
-
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
-
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
Re: FULLTEXT search pattern syntax
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
Re: FULLTEXT search pattern syntax
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
