In this chapter, you learn how to combine
WHERE clauses to create powerful and sophisticated search conditions. You also learn how to use the
WHERE clauses introduced in Chapter 6, “Filtering Data,” filter data using a single criterion. For a greater degree of filter control, MariaDB allows you to specify multiple
WHERE clauses. These clauses may be used in two ways: as
AND clauses or as
A special keyword used to join or change clauses within a
WHERE clause. Also known as logical operators.
To filter by more than one column, you use the
AND operator to append conditions to your
WHERE clause. The following code ...