title: MySQL select all and add custom field
body: <p>My current SQL query is like this:</p>
  
  <pre><code>SELECT * FROM devices GROUP BY name ORDER BY number DESC LIMIT 0,100
  </code></pre>
  
  <p>I use <code>SELECT *</code> because I need most of the fields and I don't want to add all field names one by one. (Prformance isn't important in this issue)</p>
  
  <p>But I also add a custom field to results like this:</p>
  
  <pre><code>SELECT COUNT(*) AS "times_added", * FROM devices GROUP BY name
        ORDER BY login_number DESC LIMIT 0,100
  </code></pre>
  
  <p>But latter query doesn't work. Can I add a count field and get all fields from table ?</p>