mysql 批量模糊查询_sql server数据批量模糊查询

create table t10(ID int,串码 varchar(20))

insert into t10

1, 'A0000000001' union all

select 2, 'A0000000002' union all

select 3, 'A0000000003' union all

select 4, 'A0000000004' union all

select 5, 'A0000000005' union all

select 6, 'A0000000006' union all

select 7, 'A0000000007'

-- 程序中输入的串@x

declare @x varchar(50)

select @x='A0000000003,A0000000006'

select * from t10

where 串码 between left(@x,charindex(',',@x)-1)

and substring(@x,charindex(',',@x)+1,20)

ID 串码

----------- --------------------

3 A0000000003

4 A0000000004

5 A0000000005

6 A0000000006