title: MYSql multiple replace query
body: <p>I have this</p>
  
  <pre><code>UPDATE  table 
  SET  example = REPLACE(example, '1', 'test') 
  WHERE example REGEXP '1$'
  </code></pre>
  
  <p>So this code replaces all instances of "1" in the "example" field with "test".</p>
  
  <p>I want to repeat this for 2, 3, 4 and so on.</p>
  
  <p>But it would be very inefficient to use separate querys.</p>
  
  <p>Is the any way I can do this with just one query?</p>
  
  <p>Thanks</p>