Subscriber only lesson.
Sign up to this course to view this lesson.
AND & OR Clause
We can search for multiple conditions in our Where clause using "And" & "Or".
When to use
Anytime you want to search for more than one thing, use And/Or.
To use AND/OR, just add them to your Where clause:
Where [Age] > 21 AND [First Name] LIKE 'John'
Where [Age] > 21 OR [First Name] LIKE 'John'
Hints & tips
- Anytime you want to search for more than one thing, use And/Or.
- AND means everything has to be true
- OR means at least one of the things has to be true
Lesson notes are only available for subscribers.