SELECT * FROM table WHERE FIND_IN_SET(table_column, string_of_comma_separated_values); SELECT * FROM Students WHERE FIND_IN_SET('John, Jake, Micheal, Alan, Aaron');