How to remove a specific character, in a specific table column?

Question

MySQL

There is a table, extra characters ( \ ) got lost in one column.
Question: How can they be removed?

Answer 1

update 'table' set 'field'=replace('field', '\\', '')