I am new to MySQL. I have SET data type. Currently, when I retrieve the whole recordset, I want to display the SET data type as a Yes/No for each element.

Currently, I am using string processing as I think the SET data type return a string that can be compared for each element. I already get a recordset, so I can't use any of the function provided by MySQL. I just try to find my element string inside the field. So far, it works fine... unless one of the element is a substring of other element.

What is the simplest method to display the set as Yes/No? Should I just change my SET data type to several Yes/No fields...?