MySQL 去除字段中的回车符和换行

char(10): 换行符 char(13): 回车符 1 去掉回车+换行 update tablename set field = replace(field , char(13)+char(10), ''); update tablename set field = replace(replace(field, char(10), ”), char(13), ”); 2去掉回车 update tablename set field = replace(field, char(13), ''); 3去掉换行 update tablename set field = replace(field, char(10), '');