Dynadot Aftermarket: discover domain gems worth investing in. Visit our aftermarket.

MySQL - Command to delete blanks

SpaceshipSpaceship
SpaceshipSpaceship
SpaceshipSpaceship
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
Appraise.net

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