网猫采集数据过滤

删除空数据

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