使用FTS查询，你能找到所有的条目包含'abc' [英] Using FTS query, Can you find all entries contains 'abc'

问题描述

我是全文搜索的新手，我如何使用Contains执行搜索，而不是在以下查询中使用like

 选择*来自学生FullName LIKE'％abc％'
  

谢谢

解决方案

使用以下脚本检查您的目录是上次填充的：

  DECLARE @CatalogName VARCHAR（MAX）
 SET @CatalogName ='FTS_Demo_Catalog'
 
 SELECT 
 DATEADD（ss，FULLTEXTCATALOGPROPERTY（@ CatalogName，'PopulateCompletionAge'），'1 / 1/1990'）AS LastPopulated 
，（SELECT CASE FULLTEXTCATALOGPROPERTY（@ CatalogName，'PopulateStatus'）
当0然后'空闲'
当1那么'完整人口进行中'
当2当时'已暂停'
当3当'节流'时
当4时'恢复'
当5'停止'
当6'增量人口在P rogress'
当7时'建立索引'
当8时'磁盘已满。暂停'
'9'后更改跟踪'END）AS PopulateStatus 
 FROM sys.fulltext_catalogs AS cat 
  

您可能需要重新填充全文索引才能看到当前结果。如果您定义了FTS列，然后将数据加载到表中，那么您的搜索索引不会是最新的。 $ b

如果您需要定期更新，请查看本文在Tech Net上

I am new to Full Text Search, how do I perform a search using Contains instead of using like in the following query

Select * From Students Where FullName LIKE '%abc%'

Thanks

解决方案

Check when your catalog was last populated using this script:

DECLARE @CatalogName VARCHAR(MAX)
SET     @CatalogName = 'FTS_Demo_Catalog'

SELECT
    DATEADD(ss, FULLTEXTCATALOGPROPERTY(@CatalogName,'PopulateCompletionAge'), '1/1/1990') AS LastPopulated
    ,(SELECT CASE FULLTEXTCATALOGPROPERTY(@CatalogName,'PopulateStatus')
        WHEN 0 THEN 'Idle'
        WHEN 1 THEN 'Full Population In Progress'
        WHEN 2 THEN 'Paused'
        WHEN 3 THEN 'Throttled'
        WHEN 4 THEN 'Recovering'
        WHEN 5 THEN 'Shutdown'
        WHEN 6 THEN 'Incremental Population In Progress'
        WHEN 7 THEN 'Building Index'
        WHEN 8 THEN 'Disk Full.  Paused'
        WHEN 9 THEN 'Change Tracking' END) AS PopulateStatus
FROM sys.fulltext_catalogs AS cat

You may need to re-populate your Full Text Index in order to see current results. If you defined the FTS column, and then loaded data into the table, your search index is not up to date.

If you need this to be regularly updated, check out this article on Tech Net

这篇关于使用FTS查询，你能找到所有的条目包含'abc'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！