SELECT * FROM testTable WHERE JSON_EXTRACT(create_time, “$.earlytime”) = ‘2020-11-11’;
Mysql中对于Json数据格式进行节点字段查询方法
最新推荐文章于 2023-05-19 16:29:59 发布
SELECT * FROM testTable WHERE JSON_EXTRACT(create_time, “$.earlytime”) = ‘2020-11-11’;