search

13.AND，OR 组合多个条件

AND - 并的关系

OR - 或的关系

匹配文档满足两个或两个以上的条件。

在下边的例子,我们只返回people 至少有一个孩子并且有一个gmail地址。

AND Query:

SELECT fname, email, children
    FROM tutorial 
        WHERE ARRAY_LENGTH(children) > 0 AND email LIKE '%@gmail.com'

结果：

{
  "results": [
    {
      "children": [
        {
          "age": 17,
          "fname": "Aiden",
          "gender": "m"
        },
        {
          "age": 2,
          "fname": "Bill",
          "gender": "f"
        }
      ],
      "email": "[email protected]",
      "fname": "Dave"
    },
    {
      "children": [
        {
          "age": 17,
          "fname": "Xena",
          "gender": "f"
        },
        {
          "age": 2,
          "fname": "Yuri",
          "gender": "m"
        }
      ],
      "email": "[email protected]",
      "fname": "Earl"
    },
    {
      "children": [
        {
          "age": 17,
          "fname": "Abama",
          "gender": "m"
        },
        {
          "age": 21,
          "fname": "Bebama",
          "gender": "m"
        }
      ],
      "email": "[email protected]",
      "fname": "Ian"
    }
  ]
}

在下边的例子,我们只返回 至少有一个孩子的people或有一个gmail地址的people。

OR Query:

结果：

Previous12.匹配的元素与任何嵌套的数组Next14.USE KEYS 关键词匹配查询

Last updated