title: MySQL Replace() unable to replace EXACT MATCH
body: <p>Here's the issue. My query:</p>
  
  <pre><code>UPDATE `table` SET `column` = replace(`column`,'123','456');
  </code></pre>
  
  <p>Is not going to work. Here's why:</p>
  
  <p>The numeric string '4123' now becomes '4456'.</p>
  
  <p>What I would like is for only EXACT matches (column value equals exactly '123') to be replaced. Is this not possible with a simple UPDATE SET = REPLACE() query??</p>