Swapping every matching token

Question

Accepted Answer

REPLACE(string, from, to) replaces every non-overlapping occurrence of 'from' with 'to'. Both occurrences of 'foo' are replaced, giving 'baz bar baz'. REPLACE is case-sensitive in most databases - 'FOO' would not be replaced.