I have 1000 rows in a table with 20 columns. One of the column has Resource wjich is character data type and values can be eithe General Information, Success Stories and which can be separated by commas and can be repeated multiple times in a row.
I want to find out how many times Success Stories repeats in a perticular row
Eg: In the below row string Sucess Stories repeats 2 times. So I should get the count as 2.
General Information,Success Stories,White Papers, Sucess Stories
Can anyone please help to write sql for the above logic.
View Complete Post