#包含like #不包含not like select * from 数据库表 where HouseName like '%江门奥园项目%' and HouseName like '%幢%' and HouseName not like '%商%';

#不包含not in select sum(o.PaidChargeSum) from cdj_order o where o.id not in (select d.order_id from cdj_order_detail d where d.is_canceled !=1);