title: Mysql group by in a CSV field
body: <p>What's the best way to perform a group by statement in a csv-like column using SQL (mySQL)?</p>
  
  <pre><code>Table Products Color
  +-------------+--------------+
  | Product Id  | Color        |
  +-------------+--------------+
  | 120         | Red, Blue    |
  | 121         | Green, Black | 
  | 122         | Red, Black   | 
  +-------------+--------------+
  </code></pre>
  
  <p>From the table above I need to count how many times a color appears and return something like this:</p>
  
  <pre><code>+-------------+-------+
  | Color       | Count |
  +-------------+-------+
  | Red         | 2     |
  | Blue        | 1     | 
  | Green       | 1     | 
  | Black       | 2     | 
  +-------------+-------+
  </code></pre>
  
  <p>Is possible to do this without normalize the database?</p>