删除空数据

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