SELECT userid,username, concat('【',group_concat(cardid_all ORDER BY cardid_all separator '】【'),'】') AS cardid_all FROM reports.upper_report_detail WHERE reports.upper_report_detail.rep_id ='3038' GROUP BY userid
|
||||||||||
棚号 | 姓名 | 环号 | ||||||||
160218 | 俊杰鸽业 | 【1951805,1951806】 | ||||||||
981888 | 梓淇鸽舍 | 【1951551,1951583】【1951556,1951568】【1951578,1951586】 | ||||||||
981951 | 齐成鸽舍 | 【1951111,1951293】【1951293,1951294】【1951293,1951882】 |