title: select and count where regexp group by count
body: <p>you can see what im trying to do here:</p>
  
  <pre><code>select *, count(*) as count
  from `songs`
  where `band` REGEXP '^[^[:alpha:]]'
  group by `band`
  order by `band` asc
  </code></pre>
  
  <p>bands can be:</p>
  
  <pre><code>avenged sevenfold
  3 days grace
  led zeppelin
  98 mute
  back street boys
  beastie boys
  </code></pre>
  
  <p>i need this to select the bands whose first-character is not an alpha, and count how many rows exist for each band.</p>
  
  <p>unfortunately my current query just seems to group all of them together that match the REGEXP.</p>