mysql 去除特殊字符和前后空白字符

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