title: replace multiple space with single space in a column
body: <p>There are a lot of rows with multiple spaces in column <code>title</code> and I want to replace them with a single space.</p>
  
  <pre><code>update abc set title = REPLACE(title, "  ", " ");
  </code></pre>
  
  <p>Nothing is replaced.</p>
  
  <p>I'm using phpMyAdmin.</p>
  
  <p>I noticed (clicking on the button <code>Simulate query</code> that my query is transformed into:  </p>
  
  <pre><code>update abc set title = REPLACE(title, " ", " ");
  </code></pre>
  
  <p>so replace single space with single space.</p>
  
  <p>Any help?</p>