表结构如下id 自动
vchar 字符串(里面保存着有规则的字符串 例如:1,3,6,89,43)现在想查询 表中vchar字段所有符合 客户输入数字的查询结果例如客户输入2 则在数据库中查询 vchar逗号分隔符规则中满足2的1,2 满足23,4 不满足2,78,43 满足这条查询改怎么写?
vchar 字符串(里面保存着有规则的字符串 例如:1,3,6,89,43)现在想查询 表中vchar字段所有符合 客户输入数字的查询结果例如客户输入2 则在数据库中查询 vchar逗号分隔符规则中满足2的1,2 满足23,4 不满足2,78,43 满足这条查询改怎么写?
set @s='2'
select * from tb where '%,'+@s+',%' like ','+vchar+','
--方法一:
Select * From 表 Where CharIndex(',' + Rtrim(id) + ',' , ',' + vchar + ',') > 0
Select * From 表 Where ',' + vchar + ',' Like '%,' + Rtrim(id) + ',%'
Select @ID = 2
--方法一:
Select * From 表 Where CharIndex(',' + Rtrim(@ID) + ',' , ',' + vchar + ',') >0
--方法二:
Select * From 表 Where ',' + vchar + ',' Like '%,' + Rtrim(@ID) + ',%'
select * from 表 where ','+vchar+',' like '%,2,%'
--如果在Access中:select * from 表名 where instr("," & 字段名 & ",",',2,')>0--或(纯Access)
select * from 表名 where "," & 字段名 & "," like '*,2,*'(ADO访问MDB)
select * from 表名 where "," & 字段名 & "," like '%,2,%'--如果在SQL Server中:select * from 表名 where charindex(',2,',',' + 字段名 + ',')>0--或select * from 表名 where "," & 字段名 & "," like '%,2,%'
sql="select * from En_Company where instr(," & SMT_ypxxone_id & ",,',25,')>0 order by SMT_begindate desc"还是有问题
sql="select * from En_Company where CharIndex(',25,' , ',' + Rtrim(" & SMT_ypxxone_id & ") + ',')>0 order by SMT_begindate desc"