mysql where in ²éѯ - MS-SQL Server / »ù´¡Àà

SELECT * from User where rid in (select idlist from Userlist where rid =1))
ÕâÀïselect idlist from Userlist where rid =1 idListÊÇÒ»¸övarcharÀàÐÍ£¬ÕâÀïÔõô²ÅÄܳöÕýÈ·½á¹û

---

SQL code:
SELECT * from User where ltrim(rtrim(rid)) in (select idlist from Userlist where rid =1))

ÕâÀïselect idlist from Userlist where rid =1 idListÊÇÒ»¸övarcharÀàÐÍ£¬ÕâÀïÔõô²ÅÄܳöÕýÈ·½á¹û

---

SQL code:
SELECT * from [User]
join Userlist on charindex(ltrim(rtrim(rid)),idlist)>0

---

SQL code:
select a.*
from [User] a, Userlist b
where charindex(','+ltrim(a.RID)+',',','+b.idlist+',')>0

---

Â¥ÉÏÁ½Î»mmÈ˼ұêÌâдµÄºÜÇå³þÊÇMySQL

---

cuole

ÒýÓÃ

Â¥ÉÏÁ½Î»mmÈ˼ұêÌâдµÄºÜÇå³þÊÇMySQL

---

ÒýÓÃ

Â¥ÉÏÁ½Î»mmÈ˼ұêÌâдµÄºÜÇå³þÊÇMySQL

O
·¢ÔÚMSSQL
°³Ö»ÄÜÒÔMSSQL˼ÏëÀ´Ð´
µ±ÎÒûд
°ï¶¥~~~

---

SQL code:
--try
SELECT * from User where instr(rid ,(select idlist from Userlist where ri