MySQL trailing white spaces and new line

mysql> UPDATE FOO set FIELD2 = TRIM(Replace(Replace(Replace(FIELD2,'\t',''),'\n',''),'\r',''));

References :
MySQL - how to remove white space in a mysql field - Stack Overflow