The WHERE Clause
SELECT column FROM table
WHERE column operator value
With the WHERE clause, the following operators can be used:
| Operator | Description |
| = | 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 | If you know the exact value you want to return for at least one of the columns |
Source : w3schools.com
