create table tbl_1
(
v_nm varchar(20)
)
insert into tbl_1 values('0,1')
insert into tbl_1 values('0,1,2')
insert into tbl_1 values('0,2')
insert into tbl_1 values('11,12,13')
select * from tbl_1 where v_nm like '%,1,%' or v_nm like '1,%' or v_nm like '%,1'
结果:
v_nm
--------------------
0,1
0,1,2