如果你搜索 a ,可能会出现这种问题,如果你使用 "a*" ,则表示以 a 为前缀的词,如 ab,ac
那自然就不是干扰词了。
那段英文也我看了很久,才看个明白。
The CONTAINS syntax requires double quotation marks for prefix ("choc*") and for multiple word or phrase searches ("chocolate chip" or "oatmeal"). This can be problematic in terms of UI design, because users are not accustomed to having to properly quote their searches and are prone to making mistakes when they do. A simple function is needed that developers can use to properly quote a query string before passing it to SQL Server.