mysql 中使用 json 查询，解析 json 数据

使用 json_extract()

select so.order_id,so.user_phone,so.real_name,so.user_address,so.user_phone,json_extract(esoci.cart_info, '$.productInfo.store_name') as goodsName,so.add_time from neimai.eb_store_order so 
left join neimai.eb_store_order_cart_info esoci on esoci.cart_id = json_extract(so.cart_id, '$[0]')
WHERE  so.is_system_del = 0 
and so.add_time > 1715616001;