SQL For JSON Conditions
SQL for JSON conditions allow you to test JavaScript Object Notation (JSON) data as follows:
-
IS JSON Condition lets you test whether an expression is syntactically correct JSON data.
-
JSON_EQUAL Condition tests whether two JSON values are the same.
-
JSON_EXISTS Condition lets you test whether a specified JSON value exists in JSON data.
-
JSON_TEXTCONTAINS Condition lets you test whether a specified character string exists in JSON property values.
JSON_condition::=
