 | | |||||
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.
Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
| ||||||||
| Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics. |
 |
 |
| | LinkBack | Thread Tools |
MySQL - Command to delete blanks 
08-16-2008, 01:19 PM
| #2 (permalink) |
| Senior Member  Join Date: Jul 2005 Location: NJ
Posts: 1,219
    |
__________________ Hacksar.com - Your source for random computer tips and tricks! MySiteMemberships.com - Keep track of your site registration information! Like my post? Rep is appreciated! |
|
|
08-16-2008, 01:28 PM
| #3 (permalink) |
| Domains my Dominion  Join Date: Aug 2005 Location: Web 1.0
Posts: 9,552
       | Code: UPDATE [table] SET [field]=TRIM([field])
__________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists |
|
|
|
08-16-2008, 01:31 PM
| #4 (permalink) |
| NamePros Expert  Join Date: Nov 2003 Location: Scotland
Posts: 5,069
   | 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.
__________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft |
|
|
