select GROUP_CONCAT(g.func) as func from zj_group_info g where g.groupid in (1,2) 这句怎么没有group by就直接group_concat了加上试试 select GROUP_CONCAT(g.func) as func from zj_group_info g where g.groupid in (1,2) group by groupid
你这语法写错了 where t.funid in (select g.func as func from zj_group_info g where g.groupid in (1,2))无需组合匹配成字符串 保持一个集合就可以
select t.funlv,t.name,t.url from zj_fun_info t where t.funid in (select g.func from zj_group_info g where g.groupid in (1,2)) order by t.funorder
t.funid:内容是什么 select t.funlv,t.name,t.url from zj_fun_info t where find_in_set(t.funid,(select GROUP_CONCAT(g.func) as func from zj_group_info g where g.groupid in (1,2)) >0 order by t.funorderor instr(select GROUP_CONCAT(g.func) as func from zj_group_info g where g.groupid in (1,2)),t.funid)>0
这句怎么没有group by就直接group_concat了加上试试
select GROUP_CONCAT(g.func) as func from zj_group_info g
where g.groupid in (1,2)
group by groupid
where t.funid in (select g.func as func from zj_group_info g where g.groupid in (1,2))无需组合匹配成字符串 保持一个集合就可以
(select g.func from zj_group_info g where g.groupid in (1,2))
order by
t.funorder
select t.funlv,t.name,t.url from zj_fun_info t where
find_in_set(t.funid,(select GROUP_CONCAT(g.func) as func from zj_group_info g where g.groupid in (1,2)) >0
order by
t.funorderor
instr(select GROUP_CONCAT(g.func) as func from zj_group_info g where g.groupid in (1,2)),t.funid)>0