select exam_id,substring_index(tag,',',1) as tag, substring_index(substring_index(tag,',',2),',',-1) as difficulty, substring_index(tag,',',-1) as duration from examination_info where tag like '%,%'
select exam_id,substring_index(tag,',',1) as tag, substring_index(substring_index(tag,',',2),',',-1) as difficulty, substring_index(tag,',',-1) as duration from examination_info where tag like '%,%'
牛客博客，记录你的成长
京公网安备 11010502036488号