题解 | #修复串列了的记录#

select
exam_id,
substring_index(tag,',',1) tag,
substring_index(substring_index(tag,',',2),',',-1) diffifulty,
substring_index(tag,',',-1) duration
from 
examination_info
where 
length(difficulty)=0