This simply can't be correct - if a match produces "0" score (no
relevance), the whole condition part after "AND" in this example could
be reduced to "0" (=FALSE), hence the query *should* produce 0
records:

SELECT ISBN,TITLE FROM tBooks WHERE tBooks.ISBN="1876340436" AND 0;

...and here is a real-life example of the correct behavior:

mysql> select indatetime from archivel where addr="FN20" and match
(header) against ("not_a_word");
Empty set (0.00 sec)

mysql> select indatetime from archivel where addr="FN25" and match
(header) against ("reagan");
+----------------+
| 19881201000001 |
| 19990610115359 |
| 20000515123714 |
| 19881122000001 |
| 19881122000001 |
+----------------+
5 rows in set (0.08 sec)

Regards,
Vadim P.

Victoria Reznichenko wrote:
> 
> Przemyslaw,
> Wednesday, May 22, 2002, 2:02:52 AM, you wrote:
> 
> PP> SELECT ISBN,TITLE FROM tBooks
> PP> WHERE tBooks.ISBN="1876340436"
> PP> AND MATCH (tBooks.TITLE) AGAINST ("britannica")
> 
> PP> +------------+-----------------------------+
> PP> | ISBN       | TITLE                       |
> PP> +------------+-----------------------------+
> PP> | 1876340436 | 2000 Lonely Planet Calendar |
> PP> +------------+-----------------------------+
> PP> 1 row in set (0.00 sec)
> 
> PP> Why is it so?  I suspected to get an empty result set.
> PP> MYSQL Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32)
> 
> MATCH() returnes you relevance value. So, it is always true in
> WHERE clause. As a result you get result where ISBN=1876340436. In
> your case you can re-write you query:
> 
>        SELECT ISBN,TITLE, MATCH (tBooks.TITLE) AGAINST ("britannica")
>        as aa FROM tBooks
>        WHERE tBooks.ISBN="1876340436"
>        HAVING aa>0;
> 
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com
> 
> ---------------------------------------------------------------------
> 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

Reply via email to