This article is tagged with:
Update table remove a key from json object mysql
and mysql
update table remove a key from json object mysql
UPDATE emp
SET emp.col = JSON_REMOVE(emp.col, '$.field1');