title: CONCAT multiple fields to a single field, single spaced
body: <p>I'm trying to concatenate a <code>first</code> <code>middle</code> <code>maiden</code> and <code>last</code> name fields and use that to update a single field which is named <code>fullname</code></p>
  
  <p>For each user any combination of these 4 fields can be filled. From 0 to all 4.
  However I also need a single space between each name (not multiple spaces).</p>
  
  <pre><code>UPDATE nameTable SET fullname = CONCAT(first, middle, maiden, last);
  </code></pre>