In a project I have a checkbox field called
gradeLevels with 3 options (k-5,6-8, and 9-12).
Due to design changes, I need to convert this field into a category field. I've made a new category with the same names (k-5,6-8, and 9-12), but I already have data in all of the entries that uses the old checkbox field.
I poked around in mysql and listed all the columns in craft_fields table, but I don't see the newly created categories field in the list, or any categories/entries field for that matter. I'm guessing associations are stored in a different manner?
Is there a possible way using mysql to map all the string values in the check box fields into the corresponding category in the categories field?