Using Find_in_Set in MySQL February 20, 2020 MySQL has several ways to locate a substring, and FIND_IN_SET is the right pick when your data is stored as a comma-separated list in a single column. It returns the