Invalid JSON path expression. The error is around character position 13

数字键查询报错

SELECT id from cmf_customer WHERE phone->'$.15103825200'= 15103825200
> Invalid JSON path expression. The error is around character position 13.
> 时间: 0.041s

json列内的数字field,必须用英文双引号括起来

SELECT id from cmf_customer WHERE phone->'$."15103825200"'= 15103825200
> OK
> 时间: 0.041s