What's the best way implement MS SQL full-text search using all the normal things like wildcards and quotations. For example:
使用通配符和引用等所有常规内容实现MS SQL全文搜索的最佳方法是什么。例如:
If the search term the user inputs is
如果用户输入的搜索词是
Overdose of "Vitamin C" for child*
儿童过量使用“维生素C”*
I would like to treat "Vitamin C" as one phrase and would like to match "child" and "children"
我想将“维生素C”作为一个短语,并希望匹配“孩子”和“孩子”
The documentation offers so many alternatives, it's hard to differentiate them. I'd love to be able to throw the above string at Full-text search and have it decipher the word grouping and the wildcards, but I don't think it's that smart.
文档提供了很多替代方案,很难区分它们。我希望能够在全文搜索中抛出上面的字符串并让它解读单词分组和通配符,但我认为它不那么聪明。
1 个解决方案
#1
Here is a very nice article Normalizing SQL Server Full-text Search Conditions.
这是一篇非常好的文章规范化SQL Server全文搜索条件。
It saved a bunch of time for me.
它为我节省了很多时间。
#1
Here is a very nice article Normalizing SQL Server Full-text Search Conditions.
这是一篇非常好的文章规范化SQL Server全文搜索条件。
It saved a bunch of time for me.
它为我节省了很多时间。