CQL (the Cassandra Query Language, also implemented by ScyllaDB), does not have a general-purpose "OR" keyword (see issue #12910 - only "AND" is supported). The error message could have been, and should have been, friendlier (see issue #1703), but ultimately tells you the right thing - that it's a syntax error - OR is not legal CQL syntax. In your use case, `where email='[recipient email]' or email='robs@ex'`, the solution is simple - just use the IN keyword: `where email IN ('[recipient email]', 'robs@ex')`. By the way, the `1=1` part also doesn't work, not even without OR, because currently CQL expressions are rather limited in their scope, in this case `column=value` is a valid expression, but `value=value` or other stuff, is not. Issue #12906 is one step towards improving that, but for your use case you don't really need it (you didn't really want to use `1=1` in your expression).

Context: Stack Overflow #75832433 (accepted answer, 6 votes): How does OR condition works in WHERE clause for SELECT statements in scylladb. I have created secondary index on email. Below query works fine and return result. ``` cqlsh> select * from test.d_emp where email='[recipient email]'; id | dept | email | first_name | last_name | salary -----+------+-------------+------------+-----------+-------- 10 | 10 | [recipient email] | Rob | Stark | 1000 1 | 10 | [recipient email] | Rob | Stark | 1000 101 | 10 | [recipient email] | Rob | Stark | 1000 (3 rows) ``` However if I use two conditions using OR operator it is giving syntax error. Even a simple 1=1...

## Matched source
Source: Published skill
Original query: "Is the OR operator supported in ScyllaDB?"
Key terms: operator, scylladb, supported