Removes a named key and value from a JSON map or array. Maps are in the form:

{"a": 1, "b": 2, "c": 3}

JSON_DELETE_KEY(json, keypath)

Arguments

• json: a JSON value
• keypath: the path to the key to delete (comma-separated list of dictionary keys or zero-indexed array positions).

Return Value

• The record without the key.
• SQL NULL if json is not a valid JSON.

Examples

SELECT JSON_DELETE_KEY('{"a": 1, "b": 2, "c": 3}', 'a') AS del;
+---------------+
| del           |
+---------------+
| {"b":2,"c":3} |
+---------------+

SELECT JSON_DELETE_KEY('{"a": 1, "b": 2, "c": 3}', 'z') AS nochange;
+---------------------+
| nochange            |
+---------------------+
| {"a":1,"b":2,"c":3} |
+---------------------+

SELECT JSON_DELETE_KEY('{"a":[1,2,3]}','a', 1) AS array_delete;
+--------------+
| array_delete |
+--------------+
| {"a":[1,3]}  |
+--------------+

Was this Article Helpful?

Thanks For Your Feedback!