一个sql很多个not like的简化语句

如：
select * from table where `zongbu` not like ‘%北京%’ and `zongbu` not
like ‘%上海%’ and `zongbu` not like ‘%深圳%’ and `zongbu` not like ‘天津’
and `zongbu` not like ‘香港’ and `zongbu` not like ‘沈阳’;

SELECT * FROM table WHERE zongbu NOT REGEXP ‘北京|上海|深圳|天津|香港|沈阳’;

GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY '222222' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO admin@"%" IDENTIFIED BY '222222' WITH GRANT OPTION;货品表
update iac_goods a,iac_goods_base b   set a.goods_desc=b.goods_desc where  a.goods_desc='' and b.goods_desc<>'' and b.g_id=goods_id;select goods_id,b.g_id,a.goods_desc,b.goods_desc from iac_goods as a ,iac_goods_base as b where a.goods_desc='' and b.goods_desc<>'' and b.g_id=goods_id; select goods_id,b.g_id,a.goods_desc,b.goods_desc from iac_goods as a ,iac_goods_base as b where a.goods_desc=''  and b.g_id=goods_id; //商品表select g_id,goods_name,goods_desc from iac_goods_base where goods_desc<>'';select goods_id goods_sn from iac_goods where goods_sn='';update iac_goods set goods_sn=concat('IAC', goods_id) where goods_sn='' or goods_sn not like 'IAC%';update iac_goods set goods_sn=concat('IAC', goods_id) where goods_sn='' or goods_sn not like '%IAC%';select goods_id ,goods_sn from iac_goods where goods_sn not like 'IAC%';select * from table where `zongbu` not like '%北京%' and `zongbu` not like '%上海%' and `zongbu` not like '%深圳%' and `zongbu` not like '天津' and `zongbu` not like '香港' and `zongbu` not like '沈阳'SELECT * FROM table WHERE zongbu NOT REGEXP '北京|上海|深圳|天津|香港|沈阳';

//从另一个表insert多条记录

insert into goods(goods_name,goods_price,goods_num,goods_desc,pubtime,goods_pic) select goods_name,goods_price,goods_num,goods_desc,pubtime,goods_pic from goods;