判断web死链接

--第一步
update bj_web20171204 set death='1'
where death is null and
( web_text is null or
web_text like '%域名售卖%' or
(web_text like '%502%' and web_text not like '%公司%' ) or
(web_text like '%404%' and web_text not like '%公司%' ) or
web_text like '%无法访问%' or
web_text like '%没有找到站点%' or
web_text like '%Domain not exits%' or
web_text like '%会员已终止%' or
web_text like '%Object moved to here%' or
web_text like '%is not available%' or
web_text like '%页面不存在%' or
web_text like '%网站访问报错%' or
web_text like '%服务过期提醒%' or
web_text like '%找不到网页%' or
web_text like '%已经更换新域名%' or
web_text like '%服务器错误%' or
web_text like '%Forbidden%' or
web_text like '%您的访问出错了%' or
web_text like '%您的域名已过期%'
)