You are looking at documentation for an older release.
Not what you want? See the
current release documentation.
Logical Operatorsedit
This functionality is experimental and may be changed or removed completely in a future release. Elastic will take a best effort approach to fix any issues, but experimental features are not subject to the support SLA of official GA features.
Boolean operator for evaluating one or two expressions.
-
AND
SELECT last_name l FROM "test_emp" WHERE emp_no > 10000 AND emp_no < 10005 ORDER BY emp_no LIMIT 5;
-
OR
SELECT last_name l FROM "test_emp" WHERE emp_no < 10003 OR emp_no = 10005 ORDER BY emp_no LIMIT 5;
-
NOT
SELECT last_name l FROM "test_emp" WHERE NOT emp_no = 10000 LIMIT 5;