很费解的mysql写法

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'%巍峨%')

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;

http://www.palmdy.com