Trim spaces from values in MySQL table

Trim spaces from values in MySQL table

How to Trim Spaces in MySQL ?

UPDATE <TABLE_NAME>  SET <COLUMN_NAME>=TRIM(<COLUMN_NAME>)

For Example,

UPDATE teams SET name = TRIM(name) WHERE 1 = 1;

Reference:

http://stackoverflow.com/questions/10886341/trim-spaces-from-values-in-mysql-table