title: mysql - query to remove multiple characters from column content
body: <p>Can I create a query using "replace" to remove more than one character\string from a column content ?</p>
  
  <p>For example I have:</p>
  
  <pre><code>UPDATE table1 SET column1 = REPLACE(column1, '\r\n', '');
  </code></pre>
  
  <p>But what if I want to remove multiple characters or strings like:</p>
  
  <pre><code>&lt;br /&gt;
  &lt;&amp;nbsp&gt;
  &lt;\r&gt; 
  </code></pre>
  
  <p>Is it possible to run this in  single query ?</p>