How to Search Enum Fields
I have a table with accomplishments which includes a skills field. The skills field references the skills table.
I made the skills field Enum type because I wanted to select all the skills that apply to the accomplishment entered. (1 Accomplishment can demonstrate many skills and 1 skill is found in many accomplishments)
My question is, If I want to run a search based on a skill and have it returns all the matching accomplishments with that skill, How would this work since multiple skills are saved in one cell instead of separate records?