mysql 字段前后去空格

UPDATE t_key_word SET key_word = REPLACE(REPLACE(key_word, CHAR(10), ''), CHAR(13), '')