MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE my_table(
id int,
item1 int,
item2 int,
item3 int,
item4 int );

insert into my_table values
(99,1,2,3,4),
(99,5,6,7,8),
(92,1,2,3,4),
(92,1,2,3,4);

SELECT item1, item2, item3, item4 FROM my_table  WHERE id =99;


item1
item2
item3
item4


1
2
3
4

5
6
7
8



select group_concat(CONCAT_WS(' ',item1, item2, item3, item4) SEPARATOR ' ')  as my_column
FROM my_table  WHERE id =99
group by id;


my_column


1 2 3 4 5 6 7 8