Lesson 8: Filtering results using the WHERE Clause and the IN operator.
Tidying up our WHERE clause with IN.
You can see from the previous OR operator example how your WHERE clause could get a little unwieldy after a while when using multiple different conditions.
If we were also specifying date ranges, upper and lower price limits, types of holiday, number of passengers etc. as well it could become VERY untidy to read and maintain.
We can do a little housekeeping to protect against that in our IDE by using brackets and liberal use of tabs. To tidy up the multiple OR conditions themselves we could also use the IN statement.
SELECT *FROM holidaysWHERE Country IN ('Spain','Portugal','Greece');
Let's tidy up the query from the last lesson. Use the IN keyword to bring back the same results i.e. everyone who has black OR brown hair.