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
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.041sjson列内的数字field,必须用英文双引号括起来SELECT id from cmf_customer WHERE phone->'$."15103