UPDATE tablename SET field = REPLACE(REPLACE(field, CHAR(10), ”), CHAR(13), ”); 来源:http://www.gowhich.com/blog/446