Mysql search with Match Against 搜索相关词

Question

是否可以使用 Mysql 的 MATCH AGAINST 来搜索与其相关的术语？

例如，我可以通过搜索信息来获取信息吗？我知道可以使用带有 % 符号的 LIKE，但不幸的是，LIKE 无法计算相关性。

按相关性对结果进行排序并同时能够搜索相关词的最佳方式是什么？

Answer 1

如 this blog post 中所示, MySQL fulltext订购时速度很慢。 Apache Lucene将是另一种选择。

也可以考虑相关性。这是 Lucene features 的完整列表:

Scalable, High-Performance Indexing

• over 95GB/hour on modern hardware
• small RAM requirements -- only 1MB heap
• incremental indexing as fast as batch indexing
• index size roughly 20-30% the size of text indexed

Powerful, Accurate and Efficient Search Algorithms

• ranked searching -- best results returned first
• many powerful query types: phrase queries, wildcard queries, proximity queries, range queries and more
• fielded searching (e.g., title, author, contents)
• date-range searching
• sorting by any field
• multiple-index searching with merged results
• allows simultaneous update and searching

Cross-Platform Solution

• Available as Open Source software under the Apache License which lets you use Lucene in both commercial and Open Source programs
• 100%-pure Java
• Implementations in other programming languages available that are index-compatible