27,581
社区成员




USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL
DROP TABLE t
GO
CREATE TABLE t(
[content] NVARCHAR(MAX)
)
GO
INSERT INTO t VALUES ('质地很好')
INSERT INTO t VALUES ('觫感很好')
INSERT INTO t VALUES ('质感很好')
INSERT INTO t VALUES('都不是很好')
GO
-------以上为测试表及测试数据-------------
SELECT * FROM t AS a INNER JOIN
(VALUES ('质地'),('觫感'),('质感')) b(searchStr)
ON a.[content] LIKE '%'+b.searchStr+'%'