- 方法1
select json->>'$.attr' from table;
- 方法2
select JSON_UNQUOTE(json_extract(json,'$.attr')) from table;
mysql json 查询结果去掉双引号 “”
最新推荐文章于 2024-07-28 19:31:32 发布
select json->>'$.attr' from table;
select JSON_UNQUOTE(json_extract(json,'$.attr')) from table;