MYSql multiple replace query

Question

I have this

UPDATE  table  SET  example = REPLACE(example, '1', 'test')  WHERE example REGEXP '1$' 

So this code replaces all instances of "1" in the "example" field with "test".

I want to repeat this for 2, 3, 4 and so on.

But it would be very inefficient to use separate querys.

Is the any way I can do this with just one query?

Thanks

Answer 1

Matryoshka-way ;-)

REPLACE(REPLACE(REPLACE(example, '3', 'test') , '2', 'test') , '1', 'test')