UPDATE `table` SET `title` = REPLACE(`title`, 'NM', '**') WHERE `id` > 8888926;#替换题目中所有带有 “NM” 字符为 “**”
UPDATE `table` SET `title` = REPLACE(REPLACE(`title`, CHAR(10), ''), CHAR(13), '') WHERE `id` > 8888926;#替换题目换行和回车字符
注意:在处理大数据量替换时,需要分批次替换,别乱来!!!