> even backwards-comprehend the code using the documentation. Where on earth
> did you learn to code like this? A one-liner at that, even on an 80-column
> terminal.
>
> Thank you very much!
>
> Tim Legg
> --- On Thu, 11/5/09, Kyong Kim wrote:
>
>> From: Kyong Ki
t; From: Kyong Kim
> Subject: Re: Removing 1st character of string for all entries in field
> To: "Tim Legg"
> Cc: mysql@lists.mysql.com
> Date: Thursday, November 5, 2009, 3:52 PM
> I think you can use update replace.
> UPDATE table SET column=REPLACE(column,'$'
I think you can use update replace.
UPDATE table SET column=REPLACE(column,'$','');
Kyong
On Thu, Nov 5, 2009 at 1:35 PM, Tim Legg wrote:
> Hello,
>
> I am importing CSV data from a proprietary database into a table in MySQL.
> Due to a flaw in the proprietary software's export tool, currency
Hello,
I am importing CSV data from a proprietary database into a table in MySQL. Due
to a flaw in the proprietary software's export tool, currency values (floats)
are always exported with a '$' prefixed to them. This causes a problem where
the matching float field in the MySQL table being se
