title: How to combine multiple columns as one and format with custom strings?
body: <pre><code>SELECT id, &lt;X&gt; AS name FROM `table`
  </code></pre>
  
  <p>Basically <code>&lt;X&gt;</code> is a combination of<br>
  lastname + ', ' + firstname</p>
  
  <p>example would be</p>
  
  <pre><code>   id | name        |
     2  | Smith, Bob  |
     3  | Jones, Susy |
  </code></pre>
  
  <p>This is just an example, I don't really want to combine names so simple.</p>