mysql 5.7数据类型支持json格式

create table t_json(content json);

insert into t_json values('{"name":"howhy","age":12,"mobile":"1388888888"}');

select json_extract(content,"$.name") from t_json;

select content->>"$.name" from t_json;