MySQL group_concat跟concat_ws使用(分组后连接字符串)

SELECT

    group_concat(

        DISTINCT concat_ws(

            '',

            concat_ws(

                '|',

                ip_id,

                is_primary,

                A.note,

                B.ip

            )

        )

    )

FROM

    common_device_intranet_ip_relation AS A

LEFT JOIN common_idc_intranetip AS B ON A.ip_id = B.id

WHERE

    device_connect_id = 767

GROUP BY

    ipsegment_use_type,

    ipsegment_group_id,

    A.ipsegment_id

 

执行结果