sql id存储逗号隔开,返回替换id成name

(
        SELECT GROUP_CONCAT( soj.orgShortName SEPARATOR ',')
        FROM system_organization_jf soj
        WHERE FIND_IN_SET(soj.orgId, mainCard.subOrgIds)
    ) AS subOrgNames

 

posted @ 2024-11-29 09:20  八英里  阅读(1)  评论(0编辑  收藏  举报