title: MySQL GROUP BY with GROUP_CONCAT return all row merged?
body: <p>I ran into a problem today. I got a table with coins values :</p>
  
  <pre><code>0.01
  0.01
  0.01
  0.05
  0.10
  0.25
  1.00
  1.00
  2.00
  and so on...
  </code></pre>
  
  <p>So the main idea is to get all the value one time so 0.01, 0.05, etc..</p>
  
  <p>So I do :</p>
  
  <pre><code>SELECT Valeur FROM Mint_Coins GROUP BY Valeur
  </code></pre>
  
  <p>Now it will give me one row for each value... I want all values in one row so I use this :</p>
  
  <pre><code>SELECT GROUP_CONCAT(',', Valeur) AS Values FROM Mint_Coins GROUP BY Valeur
  </code></pre>
  
  <p>It give me again 7 rows in blob... to have blob it mean that the row are over 512 bytes... Okay, let's see when I convert that they contain... results is now :</p>
  
  <pre><code>0.01, 0.01, 0.01, 0.01
  0.05, 0.05
  etc..
  </code></pre>
  
  <p>So what I am doing wrong ? I want the result to hold in one colomn and one row like this <code>0.01,0.05,0.10,0.25,1.00,2.00</code>.</p>
  
  <p>Thanks</p>