Skip to main content

JSON_EXISTS_PATH

Description​

Used to determine whether the field specified by <path> exists in JSON data. Returns TRUE if it exists, FALSE if it does not exist.

Syntax​

JSON_EXISTS_PATH (<json_object>, <path>)

Parameters​

  • <json_object> JSON type, determine whether the path specified by <path> exists in it.
  • <path> String type, specifies the path.

Return Value​

  • BOOL type, returns TRUE if it exists, FALSE if it does not exist
  • NULL: If either <json_object> or <path> is NULL, returns NULL.

Examples​

  1. Example 1
    SELECT JSON_EXISTS_PATH('{"id": 123, "name": "doris"}', '$.name');
    +------------------------------------------------------------+
    | JSON_EXISTS_PATH('{"id": 123, "name": "doris"}', '$.name') |
    +------------------------------------------------------------+
    | 1 |
    +------------------------------------------------------------+
  2. Example 2
    SELECT JSON_EXISTS_PATH('{"id": 123, "name": "doris"}', '$.age');
    +-----------------------------------------------------------+
    | JSON_EXISTS_PATH('{"id": 123, "name": "doris"}', '$.age') |
    +-----------------------------------------------------------+
    | 0 |
    +-----------------------------------------------------------+
  3. NULL parameters
    SELECT JSON_EXISTS_PATH('{"id": 123, "name": "doris"}', NULL);
    +--------------------------------------------------------+
    | JSON_EXISTS_PATH('{"id": 123, "name": "doris"}', NULL) |
    +--------------------------------------------------------+
    | NULL |
    +--------------------------------------------------------+
    SELECT JSON_EXISTS_PATH(NULL, '$.age');
    +---------------------------------+
    | JSON_EXISTS_PATH(NULL, '$.age') |
    +---------------------------------+
    | NULL |
    +---------------------------------+