Count all same comma separated value in one column mysql

Question

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:

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

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 ?

You should change your table design. Never store multiple values in a single column — juergen d, Dec 02 '16 at 09:20
http://stackoverflow.com/questions/3653462/is-storing-a-delimited-list-in-a-database-column-really-that-bad/3653574 — e4c5, Dec 02 '16 at 09:20
@juergend Thanks for the tip, maybe i should remodel my table. — Newbie, Dec 02 '16 at 09:34

score 0 · Answer 1 · answered Dec 02 '16 at 09:33

0

Try this query

SELECT LENGTH(COLUMN) - LENGTH(REPLACE(COLUMN, ',', '')) FROM TABLE_NAME

answered Dec 02 '16 at 09:33

PravinS

2,640
3
21
25

it counts only the comma separated value but not like what i desired output – Newbie Dec 03 '16 at 01:59

Count all same comma separated value in one column mysql

1 Answers1