Saved X
Google login
SignUp with Email
X

how to remove space from column in mysql

ankitvermaonline ( Added  Oct 06, 12:00 pm )
Login

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')

More Sourcecodes

More Sourcecodes