本文介绍了SQL:Like vs Contains - 不同的结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SELECT MSDS FROM dbo.MSDSSearch3 WHERE CONTAINS(MSDS,'STYCAST ')
和
SELECT MSDS FROM dbo.MSDSSearch3 WHERE MSDS like'%STYCAST%'第一个查询将返回
'STYCAST 50300 LV'第二个将返回
'STYCAST 50300 LV' 'STYCAST 2851 BLACK'有谁知道为什么类似的会返回比包含更多的值?我运行的包含有问题吗?
解决方案这里有一个类似的帖子,重建全文目录似乎解决了这个问题: b $ b
SQL问题:使用CONTAINS()不起作用,但LIKE工作正常
I'm running two queries on a table.
SELECT MSDS FROM dbo.MSDSSearch3 WHERE CONTAINS(MSDS, 'STYCAST')And
SELECT MSDS FROM dbo.MSDSSearch3 WHERE MSDS like '%STYCAST%'The first query will return
'STYCAST 50300 LV'And the second will return
'STYCAST 50300 LV' 'STYCAST 2851 BLACK'Does anyone know why the like would return more values than the contains? Is there a problem with how I'm running contains? Thanks in advance.
解决方案Here's a similar post, where rebuilding the fulltext catalog seemed to solve the problem:
SQL Problem: Using CONTAINS() doesn't work, but LIKE works fine
更多推荐
SQL:Like vs Contains
发布评论