update table remove a key from json object mysql

JavaScript
UPDATE emp
SET emp.col = JSON_REMOVE(emp.col, '$.field1');

Source

Also in JavaScript: