MySQL全文后缀搜索(boolean模式)-(*apple) [英] MySQL Full text suffix search (boolean mode) -(*apple)

问题描述

在布尔模式下apple* 会找到apple, apples, applestore.但它不会找到我(虚拟词)Mapple，Trapple.所以我尝试使用 *apple 但这不起作用.

In boolean mode apple* will find apple, apples, applestore. But it will not find me (dummy words) Mapple, Trapple. So I tried using *apple but that doesn't work.

是否无法通过全文搜索找到以 apple 结尾的单词?还是我从文档中遗漏了什么?

Is it not possible to find for words ending in apple with full text search? Or am I missing something from the documentation?

推荐答案

试试这个

SELECT * From Table
WHERE Word like '%apple'

这篇关于MySQL全文后缀搜索(boolean模式)-(*apple)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！