hwo to remove string from column mysql code example

Example: mysql replace

REPLACE(str, find_string, replace_with)