1Filters results to only include data which meets the given condition.
2Example: Returns orders with a quantity of more than 1 item.
3SELECT * FROM orders
4WHERE quantity > 1;
1SELECT id, category, location
2FROM table
3WHERE
4(
5 category LIKE '%keyword%'
6 OR location LIKE '%keyword%'
7)