JSON

JSON_REMOVE

MySQL

Menghapus satu atau lebih elemen dari JSON document. Mengembalikan JSON tanpa path yang dihapus.

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_REMOVE(json_doc, path[, path] ...)

json_docJSONwajib

JSON document sumber

pathVARCHARwajib

Path yang akan dihapus

SQL

1 SELECT JSON_REMOVE('{"name": "John", "age": 30, "temp": 1}', '$.temp') AS result;

Menghapus field 'temp'.

Hasil

{"name": "John", "age": 30}

SQL

1 SELECT JSON_REMOVE('["a", "b", "c", "d"]', '$[1]') AS result;

Menghapus elemen index 1 ('b').

Hasil

["a", "c", "d"]

SQL

1 SELECT JSON_REMOVE(data, '$.internal', '$.debug', '$.temp')
2 FROM records;

Hapus beberapa field internal sekaligus.

Hasil

(cleaned JSON)

1	SELECT JSON_REMOVE(data, '$.internal', '$.debug', '$.temp')
2	FROM records;