MySQL 全文搜索不适用于某些单词,例如“house”;
我已经在 3 个字段中的一小部分记录上设置了全文索引(也尝试了 3 个字段的组合,并得到了相同的结果),有些单词返回结果很好,但某些单词如“house”和“澳大利亚”不这样做(有趣的是,“澳大利亚”和“家乡”这样做)。
这似乎是奇怪的行为。如果我添加“WITH QUERY EXPANSION”,我会得到结果,但它们现在不是最相关的。
有人知道这是为什么吗?否则,我将不得不求助于使用“LIKE”搜索,并且我更愿意包含相关性。
I've setup a full text index on a small selection of records across 3 fields (tried a combination of the 3 as well and had the same result), and some words return results fine, but certain ones such as 'house' and 'australia' don't (interestingly, 'australian' and 'home' do).
It seems like odd behaviour. If I add "WITH QUERY EXPANSION" I get results, but they aren't the most relevant now.
Anyone got any idea why this is? Otherwise I'm going to have to resort to using LIKE searches, and I'd prefer to have relevancy included.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
可能有以下几个原因:
如果您在 Google 中搜索“mysql stop Words”,您会发现更多关于它,因为这是让很多人感到困惑的事情之一。
It could be a couple of things:
If you search Google for "mysql stop words" you'll find a lot more about it, as it's one of those things that catches a lot of people out.