Mysql 查询JSON对象key为数字的写法

select
    `city_id`,
    avg(`custom_price`->'$."1"') as price1,
    count(*) as cnt
FROM
    `orders`
WHERE
    `prov_id` = 12
    and `status` in (3, 11)
    and `city_id` = 12
    and `add_time` > '2021-08-01'
    and JSON_VALID(custom_price)
GROUP BY
    `city_id`

赞助一杯咖啡☕️

本文由 widdy 创作，采用 知识共享署名4.0 国际许可协议进行许可
本站文章除注明转载/出处外，均为本站原创或翻译，转载前请务必署名
最后编辑时间为: Dec 16, 2021 at 09:33 am