mysql 5.6 json_mysql 列转行 并进行json截取(mysql 5.6)

set @fild='},{';selectsubstring_index(substring_index(result,',',1),':',-1) asval

,replace(substring_index(substring_index(result,',',2),':',-1),'"','') asareafrom(SELECTt1.id

,t2.num_rn

,substring_index(substring_index(t1.image_file,@fild, t2.num_rn + 1), @fild, -1) as result --列转行

FROM(SELECT

1 asid

,'[{"val":4,"area":"floor","setVal":null,"isExceed":false,"isQualified":true},{"val":11,"area":"floor","setVal":null,"isExceed":true,"isQualified":false},{"val":3,"area":"floor","setVal":null,"isExceed":false,"isQualified":true},{"val":3,"area":"walls0","setVal":null,"isExceed":false,"isQualified":true},{"val":4,"area&