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. Parentheses are required whenever you mix the operators.

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

OperatorSyntaxDescription
ANDfieldExpressionX AND fieldExpressionYtrue if both fieldExpressionX and fieldExpressionY are true.
ORfieldExpressionX OR fieldExpressionYtrue if either fieldExpressionX or fieldExpressionY is true.
NOTnot fieldExpressionXtrue if fieldExpressionX false. There’s also a comparison operator NOT IN, which is different from this logical operator.

In a WHERE clause that uses OR, records are returned even if the foreign key value in a record is null.

1SELECT Id FROM Contact WHERE LastName = 'Young' or Account.Name = 'Quarry'

Example NOT operator:

1SELECT Name FROM Account WHERE AnnualRevenue > 0 AND (NOT Type = 'Prospect')

Introduction to SOQL and SOSL
Salesforce Object Query Language (SOQL)
Typographical Conventions in This Document
Quoted String Escape Sequences
Reserved Characters
Alias Notation
SOQL SELECT Syntax
SELECT
TYPEOF
USING SCOPE
WHERE
Comparison Operators
Logical Operators
Date Formats and Date Literals in WHERE
FORMULA() (Beta)
Filter on Polymorphic Relationship Fields
Query Multi-Select Picklists
Use null in WHERE
WITH
GROUP BY
HAVING
ORDER BY
LIMIT
OFFSET
FOR VIEW and and FOR REFERENCE
UPDATE
SET OPTIONS
FOR UPDATE
SOQL SELECT Examples
SOQL SELECT Functions
Relationship Queries
Change the Batch Size in Queries
SOQL Object Limits and Limitations
Syndication Feed SOQL and Mapping Syntax
Location-Based SOQL Queries
Considerations for Querying Currency Data Using SOQL
Salesforce Object Search Language (SOSL)
Previous Versions