JSON_TYPE
json_typeβ
descriptionβ
It is used to determine the type of the field specified by json_path in JSON data. If the field does not exist, return NULL. If it exists, return one of the following types
- object
- array
- null
- bool
- int
- bigint
- largeint
- double
- string
Syntaxβ
STRING json_type(JSON j, VARCHAR json_path)
exampleβ
Refer to json tutorial
keywordsβ
json_type