现在有表abc中有两个字段
一个字段是名称是id，另外一个字段是xz。xz这个字段是类型mediumtext
xz里面的内容如下：
{"erp_store_stock":[
{"title":"维生素D滴剂(H)","bus_no":"1143","ware_id":"207950","batch_no":"ACC22051288012","id_no":"8","stall_no":"1143","stock":"1","price":29.47,"price_original":29.47,"price_unit":"29.80"},
{"title":"[扶娃]葡萄糖酸钙锌口服溶液","bus_no":"1143","ware_id":"015938","batch_no":"ACC22051988019","id_no":"1","stall_no":"1143","stock":"2","price":58.93,"price_original":58.93,"price_unit":"29.80"}]
}
用php如何才能根据id=5和xz字段中ware_id=207950 和 batch_no=ACC22051288012
出对应的price=29.47的结果并输出
id是唯一值吧，先用查询出结果，然后把xz这个字段的内容线转成josn格式，然后josn转成数组array，然后循环数组判断ware_id=207950 和 batch_no=ACC22051288012就输出结果即可了
你可以用like来进行模糊查询，比如你要查ware_id=207950，那么则字段xz like "ware_id":"015938"
上面的是查询思路，具体解决还要看你后台是什么框架。。如果是Tp框架的话，那么应该是这样的：
$word = `"ware_id":"015938"`;
$map[]=['xz','like',$word];