原文地址: https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-operators-logical.html, 原文档版权归 www.elastic.co 所有
IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
Logical Operatorsedit
Boolean operator for evaluating one or two expressions.
ANDedit
SELECT last_name l FROM "test_emp" WHERE emp_no > 10000 AND emp_no < 10005 ORDER BY emp_no LIMIT 5;
ORedit
SELECT last_name l FROM "test_emp" WHERE emp_no < 10003 OR emp_no = 10005 ORDER BY emp_no LIMIT 5;
NOTedit
SELECT last_name l FROM "test_emp" WHERE NOT emp_no = 10000 LIMIT 5;