Çë½Ì¸ö¼¬ÊÖµÄSQLÓï¾äÔõôд - .NET¼¼Êõ / ASP.NET

¸÷λ´óÏÀ£º

Âé·³°ïÎÒ¿´ÏÂÕâ¸ösqlÓï¾äÔõôд

ÎÄÕÂ±í£º

  ID, bt, nr,catid,zhuantiid(רÌâ)

 ×¨Ìâ±í£º

zid,name


  ÓÉÓÚÎÄÕ±íÖÐµÄ zhuantiid(רÌâ) ÖпÉÄÜ»á¶ÔÓ¦¶à¸öרÌ⣬¶à¸öרÌâÖ®¼äÓÃ,¶ººÅ¸ô¿ª¡£ È磺1£¬3£¬4£¬11£¬12£¬13

µ±ÎÒ°´¸÷רÌâÀ´¶ÁÈ¡ÎÄÕÂʱ¡£ÎÒµÄsqlÓï¾äÄÜÕâôдÂð£¿


È磺¶ÁÈ¡ רÌâ±íÖÐIDΪ1¶ÔÓ¦µÄÎÄÕÂ

select * from ÎÄÕ±í where zhuantiid like '%1%'

µ«ºÃÏñÕâÑù£¬»á°Ñ1£¬11£¬12£¬13¶¼È¡³öÀ´£¿


Çë½ÌÔõô´¦Àí

---

SQL code:

select * from ÎÄÕ±í where zhuantiid = 1

---

ÒýÓÃ

SQL code

select * from ÎÄÕ±í where zhuantiid = 1

zhuantiid ÊÇ NVarChar ¸ñʽ£¬²»ÊÇint ,

zhuantiid »áÓкܶàzidÖµ

¿ÉÒÔÖ±½ÓÕâÑùÂð

---

select * from ÎÄÕ±í where zhuantiid like '%,1,%' or zhuantiid like '1,%' or zhuantiid like '1'

---

ÓÃsplitÕâ¸öº¯Êý

---

¶ÔÁË£¬ÉÙorÁËÒ»¸ö or zhuantiid like '%,1'
È«ÁË°É

---

·ÈËÒÒ

---

SQL code:

select * from ÎÄÕ±í where zhuantiid like '%,1,%' or zhuantiid like '1,%' or zhuantiid like '1' or zhuantiid like '%,1'





5Â¥µÄ´ð°¸¿ÉÓá£

---

ºÜÆæ¹Ö¡£