mysql - Read JSON data from multiple file input -

table help

id    name 1     name1 2     name2  json1 = {name:name1,data:"data1"} json2 = {name:name2,data:"data2"} 

final output table

data    reference json1   1 json2   2 

i want final output table in mysql refers table , stores data json1 , json2

select "json1" data,        id reference table json1 concat('{name:', name, ',data:%}') union select "json2" data,        id reference table json2 concat('{name:', name, ',data:%}')