person
column:STRING
columns whose values are JSON strings.JSON_MATCH
predicate: JSON_MATCH(<column>, '<filterExpression>')
. For example, to find all persons whose name is "adam", the query will look like:0.7.1
, we use the old syntax for filterExpression
: 'name=''adam'''
0.7.1
, we use the old syntax for filterExpression: 'name=''adam'''
0.7.1
, we use the old syntax for filterExpression: 'addresses.number=112'
0.7.1
, we use the old syntax for filterExpression: 'name=''adam'' AND addresses.number=112'
0.7.1
, we use the old syntax for filterExpression: '"addresses[0].number"=112'
0.7.1
, we use the old syntax for filterExpression: 'phone IS NOT NULL'
0.7.1
, we use the old syntax for filterExpression: '"addresses[0].floor" IS NULL'
JSON_MATCH
predicates. E.g. to find all persons who have addresses on "main st" and have addressed in "ca" (doesn't have to be the same address):JSON_MATCH
predicates are required. E.g. to find all persons who have first address on "main st" and second address on "second st":0.7.1
, json string must be object (cannot be null
, value or array); multi-dimensional array is not supported."$.addresses[*]"='main st'
won't work.