ÇóÒ»ÌìSQLÓï¾ä

Çë´ó¼Ò°ï°ïæ ÎÒÓÐÒ»¸öÕâÑùµÄ±í
  id name PosIDs
  1 XX 1,2
  2 X1 1,3
  3 X2 2,3

 ÓÃʲôÑùµÃ²éѯÓï¾ä¿ÉÒÔ

  ²é³ö

  id = 1 name = XX posID = 2

---

SQL code:
select * from tb where id=1

---

select * from tb where id=1 and name='XX' and posids=2
????

---

SQL code:
select * from tb where id=1

---

ÓÐÖ÷¼üÂ𡣡£¡£¡£¡£

---

ÎÒÃÇÒÉ»ó

---

SQL code:
select id = 1 name = XX posID = 2

---

ÒýÓÃ

SQL code
select * from tb where id=1

Èç¹ûÄãÕâÑù²éµÄ»° ½á¹ûÊÇ

 id = 1 name = XX posID = 1,2

---

select * from tb where id=1 and name='XX' and posids=2

Õâ´ð°¸Ö±½ÓÄãû¿´????

---

ÒýÓÃ

SQL code
select id = 1 name = XX posID = 2

posID = 1,2 ¿ÉÒÔÕâÑù²é£¿

---

SQL code:
select * from tb where id=1 a