MYSQL select count of distinct values from comma separated
<p>How can I select the distinct values and relative count from data that is stored as comma separated values in MySql?</p>

<p>This is how the data in the table looks like:</p>

<pre><code>"Category"    "Values"    
"red"         "D,A,D,D"    
"yellow"      "A,A,D,D"
</code></pre>

<p>Desire Output:</p>

<pre><code>"red"    "D" "3"    
"red"    "A" "1"    
"yellow" "D" "2"    
"yellow" "A" "2"
</code></pre>

<p>Can you think of a good way in mysql to get output like the way I've done?
Thank's in advance.</p>