mysql - 在mysql全文搜索中搜索名称 "Will"

Question

我对“名称”索引运行全文搜索，但我忽略了名称“Will”，因为“will”一词位于忽略列表中。

我的数据库托管在共享主机中，无法配置它。正确搜索的可能解决方案是什么？

Answer 1

作为 fulltext search stop word says 上的 mysql 文档:

The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the stopword file or columns used for full-text indexing or searches have a character set or collation different from character_set_server or collation_server.

Case sensitivity of stopword lookups depends on the server collation. For example, lookups are case insensitive if the collation is latin1_swedish_ci, whereas lookups are case sensitive if the collation is latin1_general_cs or latin1_bin.

服务器排序规则可以在 session 级别动态设置(至少在 v5.7 中)。因此，尝试将其设置为二进制排序规则。