1.获取单层Json
select * from t_pay_order_extend where paid_info->'$.paychannel' = 4
2.获取数组Json串
select merchant_order_id,json_extract(paid_info,'$[0].paychannel') as paychannel,json_extract(paid_info,'$[0].paid') as paid from t_pay_order_extend
where json_extract(paid_info,'$[0].paychannel') = 4