Revision history [back]

Yes, ScyllaDB supports the OR operator in its CQL (Cassandra Query Language) syntax. The OR operator is used in SELECT statements to combine multiple conditions using logical OR, where at least one of the conditions must be true for the row to be returned.

For example, the following query will return all rows from the table "students" where the student's age is either 18 or 19:

SELECT * FROM students WHERE age = 18 OR age = 19;

Note that the OR operator can also be combined with the AND operator and parentheses to create more complex conditions.