ÇóÖúÒ»Ìõ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,%'
{