Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

WHERE Clause

Description

In a query, a column can be processed based on conditions. The WHERE clause specifies a search condition for data.

Syntax

WHERE search_condition

search_condition :
comparison_predicate
between_predicate
exists_predicate
in_predicate
null_predicate
like_predicate
quantified predicate
set_predicate

The WHERE clause specifies a condition that determines the data to be retrieved by search_condition or a query. Only data for which the condition is true is retrieved for the query results. (NULL value is not retrieved for the query results because it is evaluated as unknown value.)

The logical operator AND or OR can be used for multiple conditions. If AND is specified, all conditions must be true. If OR is specified, only one needs to be true. If the keyword NOT is preceded by a condition, the meaning of the condition is reserved. The following table shows the order in which logical operators are evaluated.

Priority

Operator

Function

1

()

Logical expressions in parentheses are evaluated first.

2

NOT

Negates the result of the logical expression.

3

AND

All conditions in the logical expression must be true.

4

OR

One of the conditions in the logical expression must be true.