mysql wiki

http://jackyrong.iteye.com/blog/1981610

group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符'])
 

SELECT
    ->  CONCAT (e_name, ' ', e_surname) AS engineer,
    ->  GROUP_CONCAT(DISTINCT issue_id, ' (', c.company_name,')' ORDER BY issue_id SEPARATOR ', ' ) AS 'issue (customer)'

-------------------------

//宾客类型字段值为1或2，-9选择全部

转载于:https://my.oschina.net/k2easy/blog/670787