› › ›

Операторы сравнения

Булевый оператор для сравнения с одним или несколькими выражениями.

`Equality (=)`

SELECT last_name l FROM "test_emp" WHERE emp_no = 10000 LIMIT 5;

`Null safe Equality (<=>)`

SELECT 'elastic' <=> null AS "equals";

    equals
---------------
false

SELECT null <=> null AS "equals";

    equals
---------------
true

`Inequality (<> or !=)`

SELECT last_name l FROM "test_emp" WHERE emp_no <> 10000 ORDER BY emp_no LIMIT 5;

`Comparison (<, <=, >, >=)`

SELECT last_name l FROM "test_emp" WHERE emp_no < 10003 ORDER BY emp_no LIMIT 5;

`BETWEEN`

SELECT last_name l FROM "test_emp" WHERE emp_no BETWEEN 9990 AND 10003 ORDER BY emp_no;

`IS NULL/IS NOT NULL`

SELECT last_name l FROM "test_emp" WHERE emp_no IS NOT NULL AND gender IS NULL;

`IN (<value1>, <value2>, ...)`

SELECT last_name l FROM "test_emp" WHERE emp_no IN (10000, 10001, 10002, 999) ORDER BY emp_no LIMIT 5;

© 2023-2025 Elasticsearch
As of September 2024, Elasticsearch is available under a choice of three licenses: the Server Side Public License (SSPL), the Elastic License, or the AGPLv3 (OSI approved).
Elasticsearch and the Elasticsearch logo are trademarks of Elasticsearch B.V., registered in the U.S. and in other countries.
https://www.elastic.co/guide/en/elasticsearch/reference/8.17/sql-operators.html