> -Original Message-
> From: John Berman [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 11, 2005 16:22
> To: 'Tom Crimmins'
> Cc: mysql@lists.mysql.com
> Subject: RE: Remove spaces
>
> The error is simply:
>
> [JGSGB 4.1 Host] ERROR 1064:
m Crimmins [mailto:[EMAIL PROTECTED]
Sent: 11 February 2005 22:16
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: Remove spaces
Please post the error because this looks correct.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
> -Original Message-
> F
ge-
> 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:
>
> &
gt; 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)
>
>
>
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 s
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 ha
