如何创建SQL查询以包含首字母缩略词？-HowcanIcreateaSQLquerytoalsoincludeacronyms?

Suppose I have a search for government registered charities, how can I craft my SQL query so that it also searches for acronyms of the query submitted?

假设我搜索了政府注册的慈善机构,我如何设计我的SQL查询,以便它还搜索提交的查询的首字母缩略词?

For example, if I search for 'Toronto SPCA' I would like it to return the results for 'Toronto Society for the Protect and Care of Animals'

例如,如果我搜索“多伦多SPCA”,我希望它返回“多伦多动物保护和护理协会”的结果

Is there a way I can write my TSQL so that it does this for me in a Freetext search? or do I need to parse out the acronym myself before generating the TSQL query?

有没有办法可以编写我的TSQL,以便它在Freetext搜索中为我做这个?或者在生成TSQL查询之前我是否需要自己解析首字母缩略词?

1 个解决方案