Hi!
>
> mysql> SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t;
> +------------------------------+------------------------+------------------+
> | a | b | x |
> +------------------------------+------------------------+------------------+
> | MySQL has now support | for full-text search | 0 |
> | Full-text indexes | are called collections | 0.38341854994499 |
> | Function MATCH ... AGAINST() | is used to do a search | 0 |
> | mysql has now support | for full-text search | 0 |
> | collections support | foo | 0.39634908797834 |
> +------------------------------+------------------------+------------------+
> 5 rows in set (0.00 sec)
>
> mysql> INSERT INTO t VALUES ('collections',' support');
> Query OK, 1 row affected (0.00 sec)
> mysql> SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t;
> +------------------------------+------------------------+------+
> | a | b | x |
> +------------------------------+------------------------+------+
> | MySQL has now support | for full-text search | 0 |
> | Full-text indexes | are called collections | 0 |
> | Function MATCH ... AGAINST() | is used to do a search | 0 |
> | mysql has now support | for full-text search | 0 |
> | collections support | foo | 0 |
> | collections | support | 0 |
> +------------------------------+------------------------+------+
> 6 rows in set (0.00 sec)
>
>
> Briefly, it seems to us that the x column values should have remained the same,
> or atleast > 0 after our addition of the last entry to the table. It seems
> MySQL detected matches beforehand, but not after.
>
No, you're wrong.
The relevance in computed from the semantical values of individual words,
and semantical value of the word depends on word frequency in the dataset.
Too frequent words receive semantic value 0 and are effectively ignored.
See manual.
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
