mysql不包含模糊查询

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

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