包含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);
