title: Remove white space from concatenated string fields in MySQL
body: <p>I have 3 fields I am concatenating and it's working just fine in my query, but I cannot resolve how to remove the whitespace from the merged data in the concat field.</p>
  
  <pre><code>TRIM(CONCAT(c.data1,c.data2)) AS concat_done
  </code></pre>
  
  <p><strong>Result:</strong></p>
  
  <pre><code>concat_done
  33 0250S 0450E 028NW
  </code></pre>