How to remove space from column in mysql

All spaces

UPDATE 'tableName' SET 'columnName' = REPLACE('columnName', ' ', '')
All tabs
UPDATE 'tableName' SET 'columnName' = REPLACE('columnName', '\t', '')
New lines
UPDATE 'tableName' SET 'columnName' = REPLACE('columnName', '\n', '')

First and last spaces
UPDATE 'tableName' SET 'columnName' = TRIM('columnName')

Related Sourcecode

More Sourcecode

×
Google login
SignUp with Email
X