SQL全文搜索-包含 [英] SQL Full Text Search - Contains
本文介绍了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')
参考: MSDN:全文本搜索(SQL Server) [
Refer: MSDN: Full-Text Search (SQL Server)[^]
这篇关于SQL全文搜索-包含的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文