SQL：Like vs Contains - 不同的结果 [英] SQL: Like vs Contains - Different Results

问题描述

  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 - 不同的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！