select * from IpResourceInfo awhere find_in_set(a.id,(SELECT group_concat(CAST(resourcesid AS char)) ssFROM ipmanage_smh.RoleResourceswhere roleid='7b40bdde-c4f1-4f6a-8773-a07e3e27e2e0' and resourcestype=21group by roleid))
本文共 284 字，大约阅读时间需要 1 分钟。
select * from IpResourceInfo awhere find_in_set(a.id,(SELECT group_concat(CAST(resourcesid AS char)) ssFROM ipmanage_smh.RoleResourceswhere roleid='7b40bdde-c4f1-4f6a-8773-a07e3e27e2e0' and resourcestype=21group by roleid))
转载于:https://www.cnblogs.com/zhangwei595806165/p/5056391.html