UPDATE my_table
SET my_column = TRIM(my_column),
my_other_column = TRIM(my_other_column)
etc...
Dave Merrill
> Is it possible to remove all trailing and leading spaces for selected
> fields once the data has already been loaded?
>
> Steve
--
MySQL General Mailing List
For list archives: h
Marcelo wrote:
>
> Can someone tell me how i can get(or
> can someone send me) the strip command
> for SCO Open Server 5.0.5?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>
