查询以获取两个字符串之间的常用词 [英] Query to get common words between two strings

问题描述

我需要一个 SQL 查询来获取两个句子之间的常用词.例如:

I need a SQL query to get the common words only between two sentences. For example:

句子 1:这个网站很有帮助

Sentence 1: This site is very helpful

句子 2:我需要一个有用的网站

Sentence 2: I need a helpful site

结果应该是:网站有帮助

The result should be: site helpful

另外，如果我需要将句子 1 与表字段记录进行比较以获取包含最常见单词的记录与句子 1，我该怎么办?

Also, if I need to compare sentence 1 to table field records to get the record that contains most common words to sentence 1, what can I do?

推荐答案

您的问题标题说的是 MSQL，所以我将您的问题视为 Sql Server 问题.

You question title says MSQL, so I'm taking your question as a Sql Server question.

1. 拆分功能

根据 SQL Server 版本/服务器配置，您需要一个拆分函数，该函数可以在所选的分隔符上拆分字符串.这是一个这样的函数.

Depending on SQL Server version/Server Configuration, you'll need a split function that can split a string on a delimiter of choice. Here's such a function.

CREATE FUNCTION [dbo].[fnSplit](@data NVARCHAR(MAX), @delimiter NVARCHAR(5))
RETURNS @t TABLE (rowNum int IDENTITY(1,1), data NVARCHAR(max), descriptor varchar(255) NULL)
AS
BEGIN

    DECLARE @textXML XML;
    SELECT    @textXML = CAST('<d>' + REPLACE(@data, @delimiter, '</d><d>') + '</d>' AS XML);

    INSERT INTO @t(data)
    SELECT  RTRIM(LTRIM(T.split.value('.', 'nvarchar(max)'))) AS data
    FROM    @textXML.nodes('/d') T(split)

    RETURN
END

1. 使用 split 函数查询常用词(有很多方法可以做到这一点，这里有一个).<代码>SELECT 语句1.dataFROM dbo.fnSplit('这个网站很有帮助',' ') sentence1INNER JOIN dbo.fnSplit('我需要一个有用的网站',' ') sentence2 ON sentence1.data = sentence2.data

这篇关于查询以获取两个字符串之间的常用词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！