REPLACE

REPLACE(base_string, substring_to_remove, string_to_substitute)

Replaces all occurrences of the specified substring with the substitute string.

For example:

REPLACE('hello world', 'hello' 'hi') =='hi world'