MySQL 8.0

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

CREATE TABLE mytable (
  id int,
  lessons varchar(50)
);


insert into mytable values
(1, '["3M-232", "3M-313"]'),
(1, '["3M-311", "3M-312"]'),
(1, '["3M-443", "3M-565"]'),
(1, '["4M-232", "4M-313"]'),
(1, '["4M-311", "4M-312"]'),
(1, '["4M-443", "4M-565"]');

Records: 6  Duplicates: 0  Warnings: 0


select *
from mytable
cross join JSON_TABLE(lessons, '$[*]'
                      COLUMNS (
                           lesson VARCHAR(40)  PATH '$')
                      ) j


id
lessons
lesson


1
["3M-232", "3M-313"]
3M-232

1
["3M-232", "3M-313"]
3M-313

1
["3M-311", "3M-312"]
3M-311

1
["3M-311", "3M-312"]
3M-312

1
["3M-443", "3M-565"]
3M-443

1
["3M-443", "3M-565"]
3M-565

1
["4M-232", "4M-313"]
4M-232

1
["4M-232", "4M-313"]
4M-313

1
["4M-311", "4M-312"]
4M-311

1
["4M-311", "4M-312"]
4M-312

1
["4M-443", "4M-565"]
4M-443

1
["4M-443", "4M-565"]
4M-565


select *
from mytable
cross join JSON_TABLE(lessons, '$[*]'
                      COLUMNS (
                           lesson VARCHAR(40)  PATH '$')
                      ) j
where j.lesson = '3M-232';


id
lessons
lesson


1
["3M-232", "3M-313"]
3M-232

id	lessons	lesson
1	["3M-232", "3M-313"]	3M-232
1	["3M-232", "3M-313"]	3M-313
1	["3M-311", "3M-312"]	3M-311
1	["3M-311", "3M-312"]	3M-312
1	["3M-443", "3M-565"]	3M-443
1	["3M-443", "3M-565"]	3M-565
1	["4M-232", "4M-313"]	4M-232
1	["4M-232", "4M-313"]	4M-313
1	["4M-311", "4M-312"]	4M-311
1	["4M-311", "4M-312"]	4M-312
1	["4M-443", "4M-565"]	4M-443
1	["4M-443", "4M-565"]	4M-565