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), ”);