如何从数据库MySQL中的巨大记录中删除特定字符？

I have many records in the database, and I would like to delete a specific character from all records in specific column.

for example I have this table

id cost    distance  
1  $1,519  21.5 miles   
2  $7,987  32.789 miles

I would like to remove all dollar signs and comma in the cost column as well I would like to delete the the word miles from distance column

so I want the final result to be

id cost  distance  
1  1519  21.5  
2  1987  32.789

can you please help how could i do this for a huge number of records?

use REPLACE on this,

UPDATE  tableName
SET cost = REPLACE(REPLACE(cost, '$', ''), ',',''),
    distance = REPLACE(distance, 'miles', '')

• SQLFiddle Demo

select id,
       replace(substring(price, 2, length(price)), '.', ''),  
       replace(distance, 'miles', '')
from *tablename*