title: Mysql query explode and count
body: <p>I have table like this:  </p>
  
  <pre><code>product_id       model        date                  computers
  ----------------------------------------------------------------
  12204            Asus         'random_date'         :::aass:::ddff:::ddfd:::dfwr:::
  12205            Acer         'random_date'         :::ersz:::dfwqq:::bbs:::
  12205            Acer         'random_date'         :::ettww:::iwoeur:::iwerq:::
  </code></pre>
  
  <p>As you see, product_id, model can duplicate. Computers field contains how much computer in current row. Separator is :::. After I group them (GROUP BY product_id) first product (12204) have 3 computer in it, and other product (12205) have 6 computers in it. So query result must be like this:  </p>
  
  <pre><code>GROUP(product_id)      model       count
  -----------------------------------------
  12204                  Asus        4
  12205                  Acer        6 
  </code></pre>
  
  <p>Is it possible do it with single query? Or I must do it at back end code (in my case python)? </p>
  
  <p>(I can't modify table, i'm working on someone else's pre-existed table)  </p>
  
  <p><strong>Edit:</strong> updated sample data format</p>