title: MySql concat a character except for the last record
body: <p>How can I concat a character to MySQL results except for the last result?</p>
  
  <p>So:</p>
  
  <pre><code>friends
  -------------
  friend-a
  friend-b
  friend-c
  friend-d
  friend-e
  </code></pre>
  
  <p>I now do <code>select concat(friends,',') from friends</code> which actually gives me each friend name with a <code>,</code>, but I don't need the <code>,</code> for the last one.</p>
  
  <p>I cannot use group_concat here due to it size restriction.</p>
  
  <p><strong>Attempting output</strong></p>
  
  <pre><code>friend-a,
  friend-b,
  friend-c,
  friend-d,
  friend-e
  </code></pre>