---specification字段的数据样本
-- [{"class_name":"精品水果5斤装","data":[{"name":"多种时令水果混装","num":"20","money":"240"}]}]
specification->>'$[0].data[0].name' as '规...
---specification字段的数据样本
-- [{"class_name":"精品水果5斤装","data":[{"name":"多种时令水果混装","num":"20","money":"240"}]}]
specification->>'$[0].data[0].name' as '规格'
-> 抽取接口带双引号， ->> 可以去掉双引号
SELECT
member_mobile AS '用户账号',
order_no as '订单号' ,
m1.goods_title as '商品标题',
r1.created_date as '下单时间',
-- m1.specification->>'$[0].data[0].name' as '规格'
'' as '规格',
contact_tel as '联系电话',
r1.`status` '状态',
m1.remark as '操作',
contact_person as '收货人',
contact_tel as '收货电话',
delivery_address as '收货地址'
FROM
- oddb.beike_mall_order r1 INNER JOIN oddb.beike_mall_order_item m1 on r1.order_id=m1.order_id where r1.`status`='wait_seller_send_goods'
