Force.com SOQL and SOSL Reference

Salesforce Object Query Language (SOQL)
SOQL Typographical Conventions
Quoted String Escape Sequences
Reserved Characters
SOQL SELECT Syntax
Condition Expression Syntax (WHERE Clause)
fieldExpression Syntax
Comparison Operators
Logical Operators
Date Formats and Date Literals
USING SCOPE
ORDER BY
LIMIT
OFFSET
UPDATE TRACKING
UPDATE VIEWSTAT
WITH filteringExpression
GROUP BY
HAVING
TYPEOF
FOR VIEW
FOR REFERENCE
Aggregate Functions
Date Functions
Querying Currency Fields in Multicurrency Organizations
Example SELECT Clauses
Relationship Queries
Change the Batch Size in Queries
SOQL Limits on Objects
Syndication Feed SOQL and Mapping Syntax
Location-Based SOQL Queries
Salesforce Object Search Language (SOSL)
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Logical Operators

Logical operators can be used in the field expression of the WHERE clause in a SOQL query. These operators are AND, OR, and NOT.

The following table lists the logical operator values that are used in fieldExpression syntax:

Operator Syntax Description
AND fieldExpressionX AND fieldExpressionY true if both fieldExpressionX and fieldExpressionY are true.
OR fieldExpressionX OR fieldExpressionY true if either fieldExpressionX or fieldExpressionY is true.

Relationship queries with foreign key values in an OR clause behave differently depending on the version of the API. In a WHERE clause that uses OR, if the foreign key value in a record is null, the record is returned in version 13.0 and later, but not returned in versions before 13.0.

The contact with no parent account has a last name that meets the criteria, so it is returned in version 13.0 and later.
NOT not fieldExpressionX true if fieldExpressionX is false.

There is also a comparison operator NOT IN, which is different from this logical operator.