mysql 根据key值查询json 报错的处理方法

select id, platform_id->"$.2" as platformId from sale_brand_platform;

ERROR 3143 (42000): Invalid JSON path expression. The error is around character position 3.

处理

select id, platform_id->'$."2"' as platformId from sale_brand_platform;  

对！没错！所查的字段需要加双引号 即可！