Say I have
update student set name = replace(name, 'one', '1')
I would just use multiple update statements, but if you absolutely must do it in one statement, just nest the replace calls:
update student set name = replace(replace(replace(name, 'one', '1'), 'two', '2'), 'three', '3')
This works because (although inefficient) calls to
replace() have no effect if the search term is not found.