mysql字段结构灵活设计,查询对应值
create table `tb_test` ( `user_id` bigint unsigned, `login_info` json, primary key (`user_id`) ) engine=innodb; insert into `tb_test` values (1, '{"tel": "13122335566", "QQ": "654321", "wechat": "jackfrued"}'), (2, '{"tel": "13599876543", "weibo": "wangdachui123"}'); select `user_id`, json_unquote(json_extract(`login_info`, '$.tel')) as 手机号, json_unquote(json_extract(`login_info`, '$.wechat')) as 微信 from `tb_test`;