Require count occurance of a field in Mysql

Asked Jan 25 '17 at 05:32

Active Jan 25 '17 at 06:02

Viewed 22 times

I have a column where some values are listed, I want to count occurrence of a combination strings

RowNo  DT1-Increased_CT_Reason_Start_to_Accept

1  ERIC_Drive Test Taking too Long;#ERIC_Lack Of GSC Resources/Queuing  DT  Drives;#ERIC_Cluster Having Too Many RF Issues Needing Tuning;#
2  ERIC_Drive Test Taking too Long;#ERIC_Lack Of GSC Resources/Queuing DT Drives;# 
3  ERIC_Drive Test Taking too Long;#
4  ERIC_Drive Test Taking too Long

I have to count the occurrences, my desired output is

DT1-Increased_CT_Reason_Start_to_Accept                   count  

ERIC_Drive Test Taking too Long                            4  
ERIC_Lack Of GSC Resources/Queuing  DT Drives              2
ERIC_Cluster Having Too Many RF Issues Needing Tuning      1

edited Jan 25 '17 at 06:02

asked Jan 25 '17 at 05:32

user2503377

Are these combination strings in different rows? If yes then applying Group By you can get the desired output – Jahangir Alam Jan 25 '17 at 05:46
No it is not in different rows. combination is in same rows – user2503377 Jan 25 '17 at 05:47
how many max ';#' in each row ? – SIDU Jan 25 '17 at 05:48
Actually It can be any number however I have observed only 3 as if now – user2503377 Jan 25 '17 at 05:49
Sometimes I have observed that # is also not available at the end , this case will happen when only one reason is available. – user2503377 Jan 25 '17 at 06:03
Try to split your row and then apply group by. try these solutions to split http://stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows – Jahangir Alam Jan 25 '17 at 06:18

Require count occurance of a field in Mysql

0 Answers0