Count all same comma separated value in one column mysql <p>I have 2 table and there's a column which contains comma separated value and I want to count all same value of that column, here's the sample table:</p> <pre><code>Client table ID | Name | Procedure 1 | Joe | Samp1,Samp2 2 | Doe | Samp1,Samp2,Samp3 3 | Noe | Samp1,Samp2 Desire Output Summary table ( For Procedure ) ID | NAME | COUNT 1 | Samp1 | 3 2 | Samp2 | 3 3 | Samp3 | 1 </code></pre> <p>Now, do you have any idea or suggestion so i can make it happen ? like add new table or is this possible with single query ?</p>