13.AND，OR 组合多个条件

AND - 并的关系

OR - 或的关系

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

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

AND Query:

SELECT fname, email, children
    FROM tutorial 
        WHERE ARRAY_LENGTH(children) > 0 AND email LIKE '[e-mail]'

结果：

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

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

OR Query:

SELECT fname, email, children
FROM tutorial
WHERE ARRAY_LENGTH(children) > 0 OR email LIKE '[e-mail]'

结果：

{
  "results": [
    {
      "children": [
        {
          "age": 17,
          "fname": "Aiden",
          "gender": "m"
        },
        {
          "age": 2,
          "fname": "Bill",
          "gender": "f"
        }
      ],
      "email": "[e-mail]",
      "fname": "Dave"
    },
    {
      "children": [
        {
          "age": 17,
          "fname": "Xena",
          "gender": "f"
        },
        {
          "age": 2,
          "fname": "Yuri",
          "gender": "m"
        }
      ],
      "email": "[e-mail]",
      "fname": "Earl"
    },
    {
      "children": null,
      "email": "[e-mail]",
      "fname": "Fred"
    },
    {
      "children": [
        {
          "age": 17,
          "fname": "Abama",
          "gender": "m"
        },
        {
          "age": 21,
          "fname": "Bebama",
          "gender": "m"
        }
      ],
      "email": "[e-mail]",
      "fname": "Ian"
    },
    {
      "email": "[e-mail]",
      "fname": "Jane"
    }
  ]
}