更新时间:2023-02-21 15:55:14
Splitting the values between the first 3 :
delimiters,
select player_name
,substring_index(stats,':',1) as col_1
,substring_index(substring_index(substring_index(stats,':',3),':',-2),':',1) as col_2
,substring_index(substring_index(stats,':',3),':',-1) as col_3
from T1