SQL中对JSON数据的查询

三种方式:

select * from biz_product_sku where JSON_EXTRACT(extra,'$.linkOldSkuId') = 2005786246
select * from biz_product_sku where extra->'$.linkOldSkuId' = 2005786246
select * from biz_product_sku where extra->>'$.linkOldSkuId' = 2005786246