UPDATE tablename SET field = REPLACE(REPLACE(field, CHAR(10), ''), CHAR(13), '');

char(10):  换行符
char(13):  回车符

参考：http://www.gowhich.com/blog/446