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.
WHERE Country IN ('Spain','Portugal','Greece');
Try the next lesson
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.
The Data. Show Answer
SELECT * FROM characters WHERE hair IN ('Black','Brown');