This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.

« Functions and Operators Logical Operators »

› › ›

Comparison Operators

edit

Comparison Operators

edit

Boolean operator for comparing against one or multiple expressions.

`Equality (=)`

edit

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

`Null safe Equality (<=>)`

edit

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

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

SELECT null <=> null AS "equals";

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

`Inequality (<> or !=)`

edit

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

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

edit

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

`BETWEEN`

edit

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

`IS NULL/IS NOT NULL`

edit

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

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

edit

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

« Functions and Operators Logical Operators »