Hi, I have a mysql varchar field that contains formatted numbers.
I need a script to change that formatted varchar to decimal.
Example of what I have in `monthlysalary` varchar field:
Example of what I need as decimal:
I need to be able to multiply the amount in the field by 0.15.
I have tried using cast(`monthlysalary` as decimal(10,2)) but it returns the following:
1,500.00 = 1.00
3,000.00 = 3.00
2,600.00 = 2.00