SQL Server 2014字数统计 [英] SQL Server 2014 Word Count

问题描述

我有一个正在搜索关键字的SQL Server数据库.

I have a SQL Server database that I'm searching for keywords.

我只需要知道一列中出现了多少个关键字即可.

All I need to know is how many of the keywords appear in a column.

例如

red,green,blue

如果该列是这样的

I like red shoes but not blue

它将返回数字2

如果该列是这样的

I like red shoes and green shoes, but green are my favourite

它还会返回数字2

2个关键字.

我愿意使用全文索引或任何必需的内容，但是我被卡住了.

Im open to using full text index or anything that is required, but Im stuck.

推荐答案

您可以为此使用字符串分隔符.这是Jeff Moden的 DelimitedSplit8K 函数.

You can use a string splitter for this. Here is the DelimitedSplit8K function by Jeff Moden.

DECLARE @str VARCHAR(8000) = 'I like red shoes and green shoes, but green are my favourite'

SELECT
    COUNT(DISTINCT ITEM)
FROM dbo.DelimitedSplit8K(@str, ' ')
WHERE
    Item IN('red', 'green', 'blue')

SQL小提琴

这篇关于SQL Server 2014字数统计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！