MySQL update to remove whitespaces
Posted by Cătălin on Wed, 13 Sep 2017
This is how you can replace spaces with MySQL update query
Replace spaces
UPDATE `table` SET `col_name` = REPLACE(`col_name`, ' ', '')Remove all tabs characters
UPDATE `table` SET `col_name` = REPLACE(`col_name`, '\t', '' )Remove all new line characters
UPDATE `table` SET `col_name` = REPLACE(`col_name`, '\n', '')Remove first and last space(s) of column
UPDATE `table` SET `col_name` = TRIM(`col_name`)