MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table PRICING_DATA (pricingJson JSON)
insert into PRICING_DATA values
('{
"product": {
    "productFamily": "Compute Instance",
    "attributes": {
        "enhancedNetworkingSupported": "Yes" } } }');
select * 
from `PRICING_DATA` 
where `pricingJson`->"$.product.productFamily" = "Compute Instance";


pricingJson


7b2270726f64756374223a207b2261747472696275746573223a207b22656e68616e6365644e6574776f726b696e67537570706f72746564223a2022596573227d2c202270726f6475637446616d696c79223a2022436f6d7075746520496e7374616e6365227d7d