MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name (
    id serial primary key,
    column_name varchar(200)
);

INSERT INTO table_name (column_name)
VALUES ('{"boom": "goes the dynamite", "foo": "bar", "number": 42}');
select * from table_name

id
column_name

1
{"boom": "goes the dynamite", "foo": "bar", "number": 42}

UPDATE table_name
SET column_name = JSON_REMOVE(column_name, '$.boom')
WHERE 1=1;

Rows matched: 1  Changed: 1  Warnings: 0

select * from table_name

id
column_name

1
{"foo": "bar", "number": 42}