求助一条SQL like语句! - .NET技术 / ASP.NET

求助一条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,%'

bran_id like '1,%' or '%,1,%'

---

SQL code:

select * from table where '%你的字符串+','%' like bran_id+','

---

引用

自己顶一下

我看错了，他们的对

---

select * from table where bran_id like '%1%'

---

引用

引用 6 楼 kkbac 的回复:

bran_id like '%1,%' or '%,1,%'


bran_id like '1,%' or '%,1,%'

11

---

select * from [表名]
where bran_id like '%1,%'
{