title: Find non-breaking space in MySql
body: <p>How can I find a non-breaking space in a MySql database?</p>
  
  <p>For instance between # and N:</p>
  
  <pre><code>## New Tech
  </code></pre>
  
  <p>I tried to select the table and click to query:</p>
  
  <pre><code>UPDATE test 
  SET text = replace (text, "&amp;nbsp;", "")
  WHERE id = 3;
  </code></pre>
  
  <p>It finds 0 results and I am sure there is </p>
  
  <p>With regex I can use also: </p>
  
  <pre><code>\xA0 
  </code></pre>
  
  <p>But I do not know how to apply that in a MySql database</p>