select a.item_id,a.order_id,b.seller_name,b.area,b.addr,c.name ,d.pay_status,d.ship_status
from sdb_b2c_order_items a join sdb_b2c_sellers b join sdb_b2c_goods c join sdb_b2c_orders d
on a.goods_id=c.goods_id and a.seller_id=b.seller_id and a.order_id=d.order_id
where (area like '%巍峨%' or area like'%让他%' or area like'%而%'or area like'%巍峨%')
from sdb_b2c_order_items a join sdb_b2c_sellers b join sdb_b2c_goods c join sdb_b2c_orders d
on a.goods_id=c.goods_id and a.seller_id=b.seller_id and a.order_id=d.order_id
where (area like '%巍峨%' or area like'%让他%' or area like'%而%'or area like'%巍峨%')
and (d.pay_status in ('1','2') and d.ship_status in ('0','2') )
//查看所有表中含有的这个字段
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'bn' group by TABLE_NAME;