Question

mysql，一个字段存了多个id并用逗号隔开，如何使用sql取出来使用

select name from B where id in (select sevice from A where id=1)为什么结果只有一个呢？ 想着把（6，9，7）都的name都查出来。应该怎么写???
SELECT NAME FROM B WHERE FIND_IN_SET(id,(SELECT service FROM A WHERE company_id=3))
用find_in_set可以终于解决了问题





Answer 1

试试下面这句行不
select name from B where id find_in_set(id,select sevice from A where id=1)

追问

报语法错误
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'find_in_set(id,select service from

Answer 2

select * from `B` where `id` IN ( 6 , 9 , 7 )

追问

我是想通过表A的setvice得到（6，9，7）。来进行使用

追答

select `name` from `B` where `id` in (select `sevice` from `A` where `id`=1)