I'd do it with a .php page. Doing it entirely from SQL would be difficult.
Create a recordset to get all of the results.
Use json_decode() to get the string transformed to an object or array.
Then update the column you need in the same loop with the value from the object.
I don't have any tutorials on this topic.