-
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,'$.text_2') = "test";
-
JSON_UNQUOTE去除结果的引号
SELECT DISTINCT(JSON_UNQUOTE(JSON_EXTRACT(data,'$.text_2'))) from tb_test WHERE JSON_EXTRACT(data,'$.text_2') = "test";
mysql json查询
最新推荐文章于 2024-07-25 16:06:56 发布