Used to specify a selection criteria for specific records:
| mysql> select First, Surname from Students WHERE Town='London'; +-------+---------+ | First | Surname | +-------+---------+ | Pam | Frost | | David | Smith | | Julia | James | +-------+---------+ 3 rows in set (0.00 sec) |
In this example, just the First and Surname fields have been requested for the criteria WHERE Town='London'
Operators
| ^ | Match at Beginning of Line |
| = | Equal |
| <> | Not equal |
| > | Greater than |
| < | Less than |
| >= | Greater than or equal |
| <= | Less than or equal |
| BETWEEN | Between an inclusive range |
| LIKE | Search for a pattern |
| IN | To specify multiple possible values for a column |
This example selects records where the Score is less than 70:
| mysql> select First, Surname from Students WHERE Score < '70'; +-------+---------+ | First | Surname | +-------+---------+ | Andy | Jones | | Phil | Watson | | Terry | Waite | +-------+---------+ 3 rows in set (0.00 sec) |