Updated on 2024-12-06 GMT+08:00

JSON Functions

Table 1 JSON functions

MySQL

Support Unplanned ALT (Yes/No)

JSON_APPEND()

Supported

JSON_ARRAY()

Supported

JSON_ARRAY_APPEND()

Supported

JSON_ARRAY_INSERT()

Supported

JSON_CONTAINS()

Supported

JSON_CONTAINS_PATH()

Supported

JSON_DEPTH()

Supported

JSON_EXTRACT()

Supported

JSON_INSERT()

Supported

JSON_KEYS()

Supported

JSON_LENGTH()

Supported

JSON_MERGE()

Supported

JSON_MERGE_PATCH()

Supported

JSON_MERGE_PRESERVE()

Supported

JSON_OBJECT()

Supported

JSON_QUOTE()

Supported

JSON_REMOVE()

Supported

JSON_REPLACE()

Supported

JSON_SEARCH()

Supported

JSON_SET()

Supported

JSON_TYPE()

Supported

JSON_UNQUOTE()

Supported

JSON_VALID()

Supported