提取第 n 个单词以后

Question

如何在 sql server 中提取从第 n 个单词开始的单词？

例如。

|描述 |
|这件衣服真好看|

从第四个单词开始，将输出“nice dress”

Answer 1

with sentences as
(
select 'short sentence' as sentence UNION ALL
select 'This is a nice dress' as sentence UNION ALL
select 'The quick brown fox jumped over the lazy dog' as sentence 
)

SELECT 
SUBSTRING(sentence,
CHARINDEX(' ', sentence,CHARINDEX(' ', sentence, CHARINDEX(' ', sentence)+1)+1),
LEN(sentence)) AS WordFourOnwards
FROM sentences
WHERE patindex('[^ ]% [^ ]% [^ ]% [^ ]%',sentence) > 0

Answer 2

如果您自己构建该方法，您可以找到第三个空格的字符串位置，然后从该位置获取正确的字符串。

编辑：charindex() 和 substring() 的组合等。