MySQL中替换回车换行符

UPDATE table_name SET field = REPLACE(REPLACE(field, CHAR(10), ''), CHAR(13), '');
-- CHAR(10):  换行符
-- CHAR(13):  回车符