求助一条SQL like语句!
table
ID name bran_id
1 ss 1,2
2 aa 10,13
3 cc 1,13,15
当bran_id like 1 的时候,结果显示的是ID=1和等于3的,而2不显示因为ID=2的bran_id,是10和13
请问我这条SQL语句该怎么写?
自己顶一下
bran_id like '%1,%' or '%,1,%' or '%,1%'
string strlike='1'
where ','+bran_id+',' like '%'+ strlike +'%'
string strlike='1'
where ','+bran_id+',' like '%,'+ strlike +',%'
SQL code:
select * from table where bran_id like '%1%'
bran_id like '%1,%' or '%,1,%'
bran_id like '1,%' or '%,1,%'
SQL code:
select * from table where '%你的字符串+','%' like bran_id+','
我看错了,他们的对
select * from table where bran_id like '%1%'
11
select * from [表名]
where bran_id like '%1,%'
{