Please post the error because this looks correct. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa
> -----Original Message----- > From: John Berman [mailto:[EMAIL PROTECTED] > Sent: Friday, February 11, 2005 16:05 > To: 'Homam S.A.' > Cc: mysql@lists.mysql.com > Subject: RE: Remove spaces > > Thanks for this > > > I did this: > > update mc_census set surname = trim(surname) > > however it fails with a syntax error ? > > I'm on 4.1 > > Regards > > John B > > -----Original Message----- > From: Homam S.A. [mailto:[EMAIL PROTECTED] > Sent: 11 February 2005 21:29 > To: mysql@lists.mysql.com > Subject: Re: Remove spaces > > 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
