MySQL - Command to delete blanks

SpaceshipSpaceship
SpaceshipSpaceship
Spacemail by SpaceshipSpacemail by Spaceship
Watch

freeflow

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

Thanks.
 
0
Close
The views expressed on this page by users and staff are their own, not those of NamePros.
GoDaddyGoDaddy
0
Close
Code:
UPDATE [table] SET [field]=TRIM([field])
 
0
Close
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.
 
0
Close
DomainEasy: white label portfolios are live. Enable yours.

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com

NamePros updates

Filters for activity feeds
Your news feed, Latest activity, and the activity tab on profiles now have filter buttons: All, Posts, Quick replies, and Other. Your...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back