REPLACE

The replace function replaces every occurrence of a search_string with a new string. If no new string is specified, all occurrences of the search_string are removed.

Example: replace('a1a1a1','a','2') = '212121'.