Ask Your Question
2

Does ScyllaDB support the OR operator?

asked 2023-07-03 06:43:31 +0000

nofretete gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2023-07-03 07:01:01 +0000

bukephalos gravatar image

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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2023-07-03 06:43:31 +0000

Seen: 14 times

Last updated: Jul 03 '23