MySQL - Command to delete blanks

[freeflow]

How can I delete all blank spaces before and after all entries
in a specific column in a database.

Thanks.

 

[nasaboy007]

http://www.1keydata.com/sql/sql-trim.html

Use the SQL TRIM function.

 

[Kate]

UPDATE [table] SET [field]=TRIM([field])

 

[Peter]

If you already have the data in the tables then the following sql command will remove the speaces

UPDATE TABLE_NAME SET colum_name = trim(column_name)

oops too late sdsinc just posted near enough the same thing.