We’re rewarding the question askers & reputations are being recalculated! Read more.

The syntax of the condition expression in a WHERE clause of a SOQL query includes one or more field expressions. You can specify multiple field expressions to a condition expression by using logical operators.

The conditionExpression in the WHERE clause in a SOQL statement uses the following syntax:

fieldExpression [logicalOperator fieldExpression2][...]

You can add multiple field expressions to a condition expression by using logical operators.

SELECT Id FROM Contact WHERE Name LIKE 'A%' AND MailingState='California'
history | excerpt history