SQL全文搜索-包含 [英] SQL Full Text Search - Contains

查看：87 发布时间：2019/6/18 14:58:26 SQL SQL-Server

本文介绍了SQL全文搜索-包含的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

这不起作用，请帮忙..

this is not working please help..

SELECT * FROM Company c WHERE 1=1 and CONTAINS  (c.FullCompanyName, ' "Baresso*" AND "Coffe*" AND "A/S*"')

Baresso Coffe A/S

it is not giving output with Baresso Coffe A/S

不提供输出信息不确定您写的WHERE子句之王！
WHERE 1 = 1吗?

试试:

Not sure what king of WHERE clause you have written!
WHERE 1=1 ?

Try:

SELECT 
   * 
FROM 
   Company c 
WHERE 
   c.FullCompanyName LIKE '%Baresso%'

上面的查询将获取其中包含 Baresso 的公司名称的记录.

更新:
另类:

Above query will fetch the records for company name that has Baresso in it.

UPDATE:
Alternative:

SELECT 
   * 
FROM 
   Company c 
WHERE 
   CONTAINS  (c.FullCompanyName, 'Baresso' AND 'Coffe' AND 'A/S')

Refer: MSDN: Full-Text Search (SQL Server)[^]

这篇关于SQL全文搜索-包含的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！