MySQLで文頭・文末の空白を消したいとき

文末の空白を消したいとき

UPDATE [table_name] SET [column_name] = TRIM(TRAILING ' ' FROM [column_name]);

頭のとき

UPDATE [table_name] SET [column_name] = TRIM(LEADING ' ' FROM [column_name]);