How to remove unwanted string inside database column

Ever wonder how to remove unwanted string in database column? It's easy! 

For example, you have created a "map" table with column "location" and you want to delete the comma.

To delete the comma, you can use the query below:

UPDATE DATABASE_NAME.TABLE_NAME set FIELD_NAME = replace(FIELD_NAME,'find this string', 'replace found string with this string');

The query should look something like this. (Lets said the database that we used called "country")

UPDATE country.map set location =  replace( location , ',' , ' ');

After execute the query, the comma should disappear.