MySQL 5.7

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

CREATE TABLE TableDate(
month int(20),	
json varchar(500)
)
INSERT TableDate (month,json)
VALUES 
('01','[" 99/01/04", " 99/01/05", " 99/01/06", " 99/01/07"]'),
('02','[" 99/02/04", " 99/02/05", " 99/02/06", " 99/02/07"]'),
('03','[" 99/03/04", " 99/03/05", " 99/03/06", " 99/03/07"]')
#原本的Table
select * from TableDate


month
json


1
[" 99/01/04", " 99/01/05", " 99/01/06", " 99/01/07"]

2
[" 99/02/04", " 99/02/05", " 99/02/06", " 99/02/07"]

3
[" 99/03/04", " 99/03/05", " 99/03/06", " 99/03/07"]


SELECT month,SUBSTRING(json,4,8) AS F1
FROM TableDate
UNION ALL
SELECT month,SUBSTRING(json,17,8) AS F1
FROM TableDate
UNION ALL
SELECT month,SUBSTRING(json,30,8) AS F1
FROM TableDate
UNION ALL
SELECT month,SUBSTRING(json,43,8) AS F1
FROM TableDate
ORDER BY month,F1


month
F1


1
99/01/04

1
99/01/05

1
99/01/06

1
99/01/07

2
99/02/04

2
99/02/05

2
99/02/06

2
99/02/07

3
99/03/04

3
99/03/05

3
99/03/06

3
99/03/07

month	json
1	[" 99/01/04", " 99/01/05", " 99/01/06", " 99/01/07"]
2	[" 99/02/04", " 99/02/05", " 99/02/06", " 99/02/07"]
3	[" 99/03/04", " 99/03/05", " 99/03/06", " 99/03/07"]

month	F1
1	99/01/04
1	99/01/05
1	99/01/06
1	99/01/07
2	99/02/04
2	99/02/05
2	99/02/06
2	99/02/07
3	99/03/04
3	99/03/05
3	99/03/06
3	99/03/07