title: How to concat_ws multiple fields and remove duplicate separators for empty slots
body: <p>When you <code>CONCAT_WS(' ',field1,field2,field3)</code> in MySQL and if one of the fields is empty, not null, you get multiple separators. </p>
  
  <p>An example can be:</p>
  
  <pre><code>John[space][space][space]Doe[space]III.
  </code></pre>
  
  <p>How can I make sure there is only one separator.</p>