mysql数据库函数 concat 字段类型转化、字段拼接

    select
        l.lid,
        GROUP_CONCAT(s.NAME) shopname,
        m.realname,
        u.NAME,
        m.phone,
        a.name,
        concat(l.progress,‘‘)
    from
        loan l,
        bank b,
        merchant m,
        bank_user u,
        area a,
        shop s 
    where
        l.bid=b.bid 
        and l.mid=m.mid 
        and l.uid=u.uid  
        and b.aid=a.id 
        and l.lid=s.lid 

    GROUP BY
        l.lid