Re: Inconsistency in Mysql Full text Indexing

[Jiayi Hoffman]

Thanks Peter for pointing out that Natural Language Mode is only for the whole word. It makes sense. I tried the Boolean Mode as you suggested, and it works great. Thanks! :)

SELECT f1, tenant_id, match(F_400011_0) AGAINST ('vapp*' IN BOOLEAN MODE) AS RELEVANCE FROM tft where match(F_400011_0) AGAINST ('vapp*' IN BOOLEAN MODE);

+-----------------------------------------------+-----------+--------------------+
| f1 | tenant_id | RELEVANCE |
+-----------------------------------------------+-----------+--------------------+
| client_5_009eda6c-dd43-4cd8-83c6-3899afcccf62 | client_5 | 0.0906190574169159 |
+-----------------------------------------------+-----------+--------------------+
1 row in set (0.01 sec)