title: Count all same comma separated value in one column mysql
body: <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>