title: Mysql Group by column names
body: <p>I've written a query where I select the likes and the dislikes out of a column. I get the results but now I want to add a name to each of the grouped result, is this possible ?</p>
  
  <p>Table structure:</p>
  
  <p><code>id</code> ,
  <code>snippet_id</code> ,
  <code>user_id</code> ,
  <code>kind</code> </p>
  
  <p>the query:</p>
  
  <pre><code>SELECT COUNT(v) as likes FROM Vote v GROUP BY v.kind
  </code></pre>
  
  <p>The result I get:</p>
  
  <p>array(0 => 10, 1 => 3);</p>
  
  <p>I want a result like this:</p>
  
  <p>array('likes' => 10, 'dislikes' => 3);</p>