By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE results (
`name` VARCHAR(5),
`device` VARCHAR(8),
`passed` INTEGER,
`failed` INTEGER
);
INSERT INTO results
(`name`, `device`, `passed`, `failed`)
VALUES
('test1', 'device_1', '2', '1'),
('test1', 'device_2', '3', '0'),
('test2', 'device_1', '1', '2'),
('test2', 'device_2', '2', '1');
Records: 4 Duplicates: 0 Warnings: 0
SELECT CONCAT('[', GROUP_CONCAT(CONCAT('(', CONCAT_WS(',', name, device, passed, failed), ')')), ']') AS result
FROM results
GROUP BY name
| result |
|---|
| [(test1,device_1,2,1),(test1,device_2,3,0)] |
| [(test2,device_1,1,2),(test2,device_2,2,1)] |