Mysql去除换行符

UPDATE app_forecast SET  location = REPLACE(REPLACE(location, CHAR(10), ''), CHAR(13), '');