MySQL - Command to delete blanks

freeflow · 08-16-2008, 12:13 PM

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

Thanks.

nasaboy007 · 08-16-2008, 12:19 PM

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

Use the SQL TRIM function.

sdsinc · 08-16-2008, 12:28 PM

Code:

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

Peter · 08-16-2008, 12:31 PM

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.

08-16-2008, 12:13 PM	#1 (permalink)
freeflow NamePros Member Join Date: Dec 2006 Posts: 135 12.00 NP$ (Donate)	MySQL - Command to delete blanks How can I delete all blank spaces before and after all entries in a specific column in a database. Thanks.

08-16-2008, 12:19 PM	#2 (permalink)
nasaboy007 Senior Member Join Date: Jul 2005 Location: NJ Posts: 1,112 1,454.30 NP$ (Donate)	http://www.1keydata.com/sql/sql-trim.html Use the SQL TRIM function. __________________ 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, 12:28 PM	#3 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,284 1,095.94 NP$ (Donate)	Code: UPDATE [table] SET [field]=TRIM([field]) __________________ Buy now - MassDeveloper.com $500

08-16-2008, 12:31 PM	#4 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)