title: MySQL for replace with wildcard
body: <p>I'm trying to write a SQL update to replace a specific xml node with a new string:</p>
  
  <pre><code>UPDATE table
  SET Configuration = REPLACE(Configuration,
       "&lt;tag&gt;%%ANY_VALUE%%&lt;/tag&gt;"
       "&lt;tag&gt;NEW_DATA&lt;/tag&gt;");
  </code></pre>
  
  <p>So that </p>
  
  <p><code>&lt;root&gt;&lt;tag&gt;SDADAS&lt;/tag&gt;&lt;/root&gt;</code></p>
  
  <p>becomes</p>
  
  <p><code>&lt;root&gt;&lt;tag&gt;NEW_DATA&lt;/tag&gt;&lt;/root&gt;</code></p>
  
  <p>Is there a syntax im missing for this type of request?</p>