mysql json 字段获取值
PG
get_json_object(remark, '$.字段英文名')
-- MYSQL
aa=[{"tableName":"CBONDDESCRIPTION","alias":"a","tableId":476}]
JSON_UNQUOTE(JSON_EXTRACT(aa,'$[0].tableName')) as ddd,
ps:JSON_UNQUOTE 去除双引号
中文记得双引号哦 JSON_UNQUOTE(JSON_EXTRACT(resps, '$."合并资产负债表"')) AS table_name_value