Skip to main content

SELECT Where

Specifies the search condition for the rows returned by the query.

bSQL Syntax Conventions

Syntax

[ WHERE <search_condition> ]  

Arguments

\< search_condition > Defines the condition to be met for the rows to be returned. There is no limit to the number of predicates that can be included in a search condition.

<search_condition> ::= 
{ ( <search_condition> ) }
[ { AND | OR } { <predicate> | ( <search_condition> ) } ]
[ ,...n ]

<predicate> ::=
{ expression { = | ! = | > | > = | < | < = } expression
| ISNULL(expression)
| ~ "regex_expression"

Examples

The following examples show how to use some common search conditions in the WHERE clause.

A. Finding a row by using a simple equality

SELECT sector
FROM companies
WHERE name = "Boston Properties"

B. Finding rows that contain a value as part of a string

SELECT symbol
FROM financial.companies
WHERE symbol ~ "^[a-eA-E]*$"

C. Finding rows by using a comparison operator

SELECT symbol, price  
FROM financial.pricing
WHERE price <= 500

D. Finding rows that meet any of two conditions

SELECT *
FROM financial.companies
WHERE name = "Humana Inc." OR name = "Ecolab Inc."

E. Finding rows that must meet several conditions

SELECT symbol  
FROM financial.pricing
WHERE pricing < 100 AND 52_week_low > 90

See Also