Find text within a comma delimitated string

I have a column with comma delimitated data string: 1) abc 2) abc,xyz 3) idf,abc 4) pdq,abc,xyz 5) mabc,xyz 6) idf,abcd   I am trying to show any data set with ID abc in it and i can pick out...