How to remove characters or string from a mysql table

update tablename set column_name = replace(column_name, ‘find string to replace’, ‘replace with this string’);

Forr example, if you have asterisks in your data you want to delete:

update cities set city = replace(city, ‘*’, ”);