title: How to group mysql rows with same column value into one row?
body: <p>I have two tables, keywords and data. </p>
  
  <p>Table keywords have 2 columns (id, keyword), table data have 3 columns (id[foreign key of keywords.id], name, value).</p>
  
  <p>I am using this query:</p>
  
  <pre><code>SELECT k.id, d.value, d.name
  FROM keywords AS k
  INNER JOIN data as d ON k.id = d.id
  </code></pre>
  
  <p>it returns something like:</p>
  
  <pre><code>1 123 name1
  1 456 name2
  2 943 name1
  3 542 name1
  3 532 name2
  3 682 name3
  </code></pre>
  
  <p>Each id can have values from 0 to 3 (maybe more in the future).</p>
  
  <p>How can I retrieve all the rows with the same id in the same row?</p>
  
  <p>Like</p>
  
  <pre><code>1 123 456
  2 943
  3 542 532 682
  </code></pre>
  
  <p>I want to do this because I want to be able to sort the values.</p>