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