MySQL 8.0

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

select version();


version()


8.0.30


create table myTable(id int, listofnumbers varchar(200));
insert into myTable values(2,	'[1, 2, 5, 6, 7]');
insert into myTable values(5,	'[1, 2, 13, 51, 12]');
select t.id, j.listofnumbers
from myTable t
join json_table(
  t.listofnumbers,
  '$[*]' columns (listofnumbers varchar(50) path '$')
) j;


id
listofnumbers


2
1

2
2

2
5

2
6

2
7

5
1

5
2

5
13

5
51

5
12