80后的细娃儿

网猫采集数据过滤

 

删除空数据



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



点赞