title: How to concat multiple fields with line breaks
body: <p>I have a MySQL table that has 5 columns I want to combine into one but with line breaks, i.e.</p>
  
  <pre><code>Select
  concat(field1, field2, field3, field4, field5) as MyQuery
  from MyTable
  </code></pre>
  
  <p>I need to change this either in SQL table itself or as an insert function, so that there are line breaks, the field is formatted as medium text, so would look like this:</p>
  
  <pre><code>Line 1 
  Line 2 
  Line 3 
  Line 4 
  Line 5 
  </code></pre>
  
  <p>Any ideas, please?</p>