62,025
社区成员
发帖
与我相关
我的任务
分享
declare @key nvarchar(100) = '104,112'
declare @x xml
set @x = '<a>' + REPLACE(@key,',','</a><a>') + '</a>'
;with xx as ( select T.d.query('text()') as result from @x.nodes('/*') as T(d) )
select * from [SClient] where exists
( select * from xx where sclient.ip like '%'+CONVERT(varchar,xx.result)+'%' )
string param = "%美食 零食 家常菜%";
param = param.Trim('%');
param = "(WxName like N'%" + param.Replace(" ", "%' OR WxName like N'%") + "%')";
你得提前知道字段名WxName string param="%美食 零食 家常菜%";
param=param.Replace(" ", "%' OR '%");