update table remove a key from json object mysql

52

update table remove a key from json object mysql -

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

Comments

Submit
0 Comments