title: How to pivot this table in MySQL
body: <p>How would you pivot this table in MySQL? It is ordered by date desc.</p>
  
  <pre><code>+--------+----------+-----------+
  | grpid  | status   | msg       |
  +--------+----------+-----------+
  |      1 | OK       | text6     |
  |      1 | PROGRESS | text5     |
  |      1 | PROGRESS | text4     |
  |      2 | FAIL     | text3     |
  |      2 | PROGRESS | text2     |
  |      2 | PROGRESS | text1     |
  +--------+----------+-----------+
  </code></pre>
  
  <p>to this form:</p>
  
  <pre><code>+--------+----------+-------------------+
  | grpid  | status   | progress          |
  +--------+----------+-------------------+
  |      1 | OK       | text4,text5,text6 |
  |      2 | FAIL     | text1,text2,text3 |
  +--------+----------+-------------------+
  </code></pre>