mysql-strtra currency2numeric

select replace(comment,'\n',''),comment from CUSTOMER;

update SALES_ORDER_INV_DESC SET PRICE= replace('123,123.12',',','') WHERE PRICE=123.11;