In my data set, I have lists of comma separated values (JSON) within MySQL data fields.

Example, in my inventory table I have three columns, first an id column then two more called eligible_vehicle_type and weight_class. These are example JSON-ified values within this table, as you can see it is a list of things:

id = 1
eligible_vehicle_type= ["c","b","a"]
weight_class = ["3","2","1"]

I need a set command that will produce this result:

vehicles = ["a","b","c"] (for string values)
weight_class = ["1","2","3"] (for integer values), for id 1.

Is this feasible with a SET command?