mysql 函数group_concat用法

1.参考:https://blog.csdn.net/qq_35531549/article/details/90383022

2. 工作中实际用到的例子: 

select
    org_id as orgId
    group_concat(
      distinct case
        open_platform
        when 'LJT' then '陆金通'
        when 'LXT' then '陆信通'
        else null end
        order by open_platform desc
        separator ','
      )
from
    bee_org_open_platform_info
where 
    is_deleted='0' group by org_id