title: How can I concatenate set of results in MySQL?
body: <p>I would like to join results returned in the set in MySQL with a comma as a separator string.</p>
  
  <p>For example, set returned contains:</p>
  
  <pre><code>COLUMN_X
  john
  jerry
  maria
  joseph
  gugla
  </code></pre>
  
  <p>I would like to receive the result as:</p>
  
  <pre><code>COLUMN_X-concat
  john,jerry,maria,joseph,gugla
  </code></pre>
  
  <p>is that possible? thanks.</p>
  
  <pre><code>SELECT CONCAT(rooms.ID,",") FROM rooms AS rooms LEFT JOIN inter AS i ON rooms.ID=i.value WHERE xxx=999
  </code></pre>
  
  <p>doesn't work as I would like it to as it returns separate results.</p>