Scalar functions for manipulating JSON
true
if the JSON string contains the specified key(s).
?
operator:
->
operator:
json_get
functions are available for retrieving values as
a specific type, or you can use SQL type annotations:
0
if the value does not exist or is not an integer.
0.0
if the value does not exist or is not a float.
false
if the value does not exist or is not a boolean.
->>
operator:
0
if the path does not exist or is not an object/array.