SELECT GROUP_CONCAT(f.?NAME?SEPARATOR?';')text FROM route_patrol_detail?a INNER?JOIN?route_patrol_detail_file?pf?ON?a.id?=?pf.patrolDetailId INNER?JOIN?sys_file?f?ON?pf.fileId?=?f.id INNER?JOIN?route_patrol?p?ON?p.id?=?a.patrolId WHERE p.id?=?'aa4e49a82b6f4bc88386a6b2302231b1' LIMIT?4;這是查詢出來的結果：6a7387c484c6ba5561a32d2c11571244.jpg;9c72b85ba75885c4f9d38dd69de2e77a.jpg;C543E7CE9F667F40FAFDF29EB3590C63.jpg;01035C6729E1AC51508250E5B9927D8C.jpg;20161110165137.jpg我想以分號結尾，并把他們換行分開成下面的格式6a7387c484c6ba5561a32d2c11571244.jpg;9c72b85ba75885c4f9d38dd69de2e77a.jpg;C543E7CE9F667F40FAFDF29EB3590C63.jpg;01035C6729E1AC51508250E5B9927D8C.jpg;20161110165137.jpg