网猫采集数据过滤

2,136次阅读
没有评论

 

删除空数据



DELETE FROM `nm_codes` WHERE `code` LIKE CONVERT(_utf8 '%<nm:name></nm>%' USING gbk) COLLATE gbk_chinese_ci



删除 ERROR 数据



DELETE FROM `nm_codes` WHERE `code` LIKE CONVERT(_utf8 'error' USING gbk) COLLATE gbk_chinese_ci



替换分类 替换国产剧为 连续剧



UPDATE `nm_movies` SET `cat` = 'gcj' WHERE `cat` LIKE CONVERT(_utf8 'lxj' USING gbk) COLLATE gbk_chinese_ci



 

替换无分类为国产剧



 

UPDATE `nm_movies` SET `cat` = 'gcj' WHERE `cat` LIKE CONVERT(_utf8 '' USING gbk) COLLATE gbk_chinese_ci



正文完
 0
评论(没有评论)
验证码