记录一下sql

最新推荐文章于 2024-09-12 15:31:55 发布

HIstoryq

最新推荐文章于 2024-09-12 15:31:55 发布

阅读量107

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/HIstoryq/article/details/124748750

版权

 select lkg.groupName
        from lz_jshd_category lkc
        left join
        (select a.id, GROUP_CONCAT(b.group_name) as groupName
        from lz_jshd_category as a
        inner join lz_jshd_group as b on FIND_IN_SET(b.id, a.group_ids)
        group by a.id) lkg
        on lkc.id = lkg.id
        where lkc.is_deleted = 0
        <if test="categoryId != null ">
            and lkc.id = #{categoryId}
        </if>
        order by sort