IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.

« Functions and Operators Logical Operators »

› › ›

Comparison Operators

edit

Comparison Operators

edit

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

Boolean operator for comparing against one or multiple expressions.

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;

« Functions and Operators Logical Operators »