title: mysql multiple rows in one result row one table
body: <p>I have a table which looks as following:</p>
  
  <pre>
  
      + ------- + -----------+ ------------ + --------- + ---------- +
      | Info_Id | category   | EAN          | Info_Type | Info_Value |
      + ------- + -----------+ ------------ + --------- + ---------- +
      | 1       | 1          | 0123456789   | brand     | brand1     |
      | 2       | 1          | 0123456789   | type      | type1      |
      | 3       | 1          | 0123456789   | price     | 0.00       |
      | 4       | 2          | 9876543210   | brand     | brand6     |
      | 5       | 2          | 9876543210   | type      | type3      |
      | 6       | 2          | 9876543210   | price     | 15.00      |
      | 7       | 2          | 6548214656   | brand     | brand34    |
      | 8       | 2          | 6548214656   | type      | type1      |
      | 9       | 2          | 6548214656   | price     | 99.00      |
      | 10      | 3          | 245511411241 | brand     | brand324   |
      | 11      | 3          | 245511411241 | type      | type1      |
      | 12      | 3          | 245511411241 | price     | 98.00      |
      + ------- + -----------+ ------------ + --------- + ---------- +
  </pre>
  
  <p>Now, I am looking for an query that creates the following output:</p>
  
  <pre>
      + ------------ + ---------- + --------- + ---------- + ----------+
      | EAN          | category   | brand     | type       | price     |
      + ------------ + ---------- + --------- + ---------- + ----------+
      | 0123456789   | 1          | brand1    | type1      | 0.00      |
      | 9876543210   | 2          | brand6    | type3      | 15.00     |
      | 6548214656   | 2          | brand34   | type1      | 99.00     |
      | etc.         | etc.       | etc.      | etc.       | etc.      |
      + ------------ + ---------- + --------- + ---------- + --------- +
  </pre>
  
  <p>I have the following, but that does not seems to work:</p>
  
  <pre>
  
      SELECT ean,
             GROUP_CONCAT(Info_Type)    AS Info_Type,
             GROUP_CONCAT(Info_Value) AS Info_Value
      FROM tablename WHERE category=2
      GROUP BY EAN
  
  </pre>
  
  <p>However, this provides me something like:</p>
  
  <pre>
      + ------------ + ---------------- + ------------------- + 
      | EAN          | Info_Type        | Info_Value          | 
      + ------------ + ---------------- + ------------------- +
      | 0123456789   | brand,type,price | brand1,type1,0.00   |
      | 9876543210   | brand,type,price | brand6,type3,15.00  |
      | 6548214656   | brand,type,price | brand34,type1,99.00 |
      | etc.         | etc.             | etc.                |
      + ------------ + ---------------- + ------------------- +
  </pre>
  
  <p>How do I do this the right way?</p>