sql查询json格式中的内容

sale_property_values是一个json字段。想要获取该json数组中，key名字为stringValue对应的值
SELECT id,json_extract_path_text(json_array_elements(sale_property_values),'stringValue') FROM ic_sku where id = 1

 

 

 SELECT DISTINCT
t1.NAME,
t3.sku_code,
t4.ean_code,
json_extract_path_text ( json_array_elements ( t3.sale_property_values ), 'stringValue' ) AS 规格
FROM
ic_item t1,
ic_item_sku t2,
ic_sku t3,
ic_sku_price t4
WHERE
t1.ID = t2.item_id
AND t2.sku_id = t3.ID
AND t3.ID = t4.sku_id
AND t1.deleted = FALSE
AND t2.deleted = FALSE
AND t3.deleted = FALSE
AND t4.deleted = FALSE

转载于:https://www.cnblogs.com/wth21-1314/p/11532519.html