title: how to remove whitespace between two words in mysql
body: <p>I have a record like <code>Z Ion Fort</code>. Now I want to combine the word like as follows <code>ZIon Fort</code>,for that I had written a update query like</p>
  
  <pre><code> update sample1 set sname=replace(sname,' Ion ','Ion ');
  </code></pre>
  
  <p>But it is not working.</p>