JSON_EXISTS_PATH

json_exists_path

description

It is used to judge whether the field specified by json_path exists in the JSON data. If it exists, it returns TRUE, and if it does not exist, it returns FALSE

Syntax

BOOLEAN json_exists_path(JSON j, VARCHAR json_path)

example

Refer to json tutorial

keywords

json_exists_path