Transact-SQL:如何标记字符串? [英] Transact-SQL: How do I tokenize a string?

问题描述

我希望能够标记文本框中的输入字符串以进行查询.示例:用户在文本框中输入abc xyz 123".我想这样做:

I want to be able to tokenize an input string from a text box to do my query. Example: user enters "abc xyz 123" in the text box. I want to do this:

SELECT * FROM database WHERE Name contains "abc" AND "xyz" AND "123"
-- as opposed to containing "abc xyz 123"
-- please ignore my sql syntax, I am an absolute beginner

谢谢.

推荐答案

使用字符串拆分功能(例如，像 这个)，你可以有这样的东西:

Using a string split function (for example, like this one), you could have something like this:

SELECT t.*
FROM atable t
  INNER JOIN dbo.Split(@UserInput, ' ') s ON t.Name LIKE '%' + s.Data + '%'

这篇关于Transact-SQL:如何标记字符串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！