记录一下mysql解析查询json字段内容
json例如{"name":"123","mobile":"1286"}
sql:
select JSON_extract(customer_data,'$.mobile'),JSON_extract(customer_data,'$.name') from customer
customer_data是json字段
记录一下mysql解析查询json字段内容
json例如{"name":"123","mobile":"1286"}
sql:
select JSON_extract(customer_data,'$.mobile'),JSON_extract(customer_data,'$.name') from customer
customer_data是json字段