mysql json查询
JSON_EXTRACT及->的使用SELECT *, JSON_EXTRACT(data,'$.text_2'), data->'$.text_2' from tb_test;
SELECT *, JSON_EXTRACT(data,'$.text_2'), data->'$.text_2' from tb_test
WHERE JSON_EXTRACT(data,'$.t...
原创
2021-05-27 09:36:57 ·
57 阅读 ·
0 评论