UPDATE `table` SET `title` = REPLACE(`title`, 'NM', '') WHERE `id` > ;#替换题目中所有带有 “NM” 字符为 “”
UPDATE `table` SET `title` = REPLACE(REPLACE(`title`, CHAR(10), ''), CHAR(13), '') WHERE `id` > ;#替换题目换行和回车字符
注意:在处理大数据量替换时,需要分批次替换,别乱来!!!
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/213245.html原文链接:https://javaforall.net
