MySQL全文搜索如何工作？ [英] How does MySQL fulltext search work?

问题描述

我有一个很好的主意，那就是如何用MySQL实现全文搜索。我知道如何添加索引并进行查询并对结果进行排序。

但我一直试图获得更多关于它如何工作的部门信息，所以说出幕后发生的事情。 MySQL如何确定结果相关性。分数甚至意味着什么？可以达到0.1到4.6以上（我至少已经看到了，可能更多）真正被索引的是什么？

我输入的搜索字符串会发生什么？

我很感谢这里的链接或解释！ 此页面有一个很好的解释 - http：//dev.mysql。 com / doc / internals / en / full-text-search.html

I have a pretty good idea how to implement fulltext search with MySQL. I know how to add indexes and make a query and sort my results.

But I have been trying to get some more in-dept information on how it works, so to say what happens behind the scenes. How does MySQL determine the results relevance. What does the score even mean? Which can reach from 0.1 to over 4.6 (which I have seen at least, probably more) And what is really being indexed?

What happens to my search string that is entered?

I am thankful for links or explanations here!

解决方案

This page has a good explanation - http://dev.mysql.com/doc/internals/en/full-text-search.html

这篇关于MySQL全文搜索如何工作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！