mysql处理json数据

1、mysql查询版本

select version()

2、json数据查询

###数据格式###字段json ##表明user
{
"adjustmentId": "2149",
"adjustmentVersion": 1,
"bookChannel": "leo",
"engineAdjustmentId": "",
"engineAdjustmentVersion": 0,
"errorRemark": "",
"fareType": "PU",
"maxAge": 0,
}

mysql语句

1、select * from user
 u where json_extract(u.json, "$.bookChannel") like "%le%"



2、select * from user u where u.json regexp '"bookChannel":"\[\le\]\"'