update your_table set your_field = trim(your_field)
--- John Berman <[EMAIL PROTECTED]> wrote: > Hi > > I have a table with a number of fields > > The table is already populated, however some entries > have got spaces both > before and after the data. > > Future imports into the table will have the spaces > removed, however im still > stuck with my extra spaces. > > I have checked the Mysql manual but could not figure > out how to remove the > extra spaces that are already in the dbase ? > > > Any help appreciated. > > Regards > > > John B > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 265.8.7 - Release > Date: 10/02/2005 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]