差评sql

update nm_evaluation_20170821 set is_bad ='1'
where
ev_content like '%服务态度不好%'or
ev_content like '%恶劣%'or
ev_content like '%超级差%'or
ev_content like '%不喜欢%'or
ev_content like '%不满意%'or
ev_content like '%垃圾%'or
ev_content like '%吵%'or
ev_content like '%影响心情%'or
ev_content like '%骗%'or
ev_content like '%讹%'or
ev_content like '%刷单%'or
ev_content like '%蛮横%'or
ev_content like '%霉%'or
ev_content like '%难吃%'or
ev_content like '%苛刻%'or
ev_content like '%黑%'or
(ev_content like '%坑%'and ev_content not like '%不坑%') or
(ev_content like '%脏%'and ev_content not like '%不脏%') or
(ev_content like '%烂%'and ev_content not like '%没烂%') or
ev_content like '%忽悠%'or
ev_content like '%虚假%'or
ev_content like '%一片狼藉%'or
ev_content like '%不隔音%'or
ev_content like '%隔音差%'or
ev_content like '%隔音不好%'or
ev_content like '%隔音效果不好%'or
ev_content like '%不负责任%'or
ev_content like '%臭味%'or
ev_content like '%异味%'or
ev_content like '%潮湿%'or
ev_content like '%不太干净%'or
ev_content like '%不干净%'or
ev_content like '%不卫生%'or
ev_content like '%骂人%'or
ev_content like '%打人%'or
ev_content like '%没素质%'or
ev_content like '%劣质%'or
ev_content like '%冷淡%'or
ev_content like '%无理%'or
ev_content like '%加收%'or
ev_content like '%多收%'or
ev_content like '%强制购物%'or
ev_content like '%不会再来%'or
ev_content like '%性价比不高%'or
ev_content like '%性价比低%'or
ev_content like '%不值%'or
ev_content like '%再也不要来%'or
ev_content like '%烂%'or
ev_content like '%不爽%'or
ev_content like '%虫%'or
ev_content like '%蚊子%'or
ev_content like '%破%'or
ev_content like '%旧%'or
ev_content like '%废%'or
ev_content like '%乱喷%'or
ev_content like '%干瘪%'or
ev_content like '%硬是不松口%'or
ev_content like '%不买了%'or
ev_content like '%史上最差%'or
ev_content like '%不太满意%'or
ev_content like '%不满意%'or
ev_content like '%有蚂蚁%'or
ev_content like '%有蟑螂%'or
ev_content like '%蛇%'or
ev_content like '%说是2个装的，收货变成3个装，失望%'