网猫采集数据过滤

 

删除空数据



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



© 版权声明
THE END
喜欢就支持一下吧
点赞0 分享