The following operators can be used in the WHERE clause:
| Operator | Description | Example |
|---|---|---|
| = | Equal | Try it |
| > | Greater than | Try it |
| < | Less than | Try it |
| >= | Greater than or equal | Try it |
| <= | Less than or equal | Try it |
| <> | Not equal. Note: In some versions of SQL this operator may be written as != | Try it |
| BETWEEN | Between a certain range | Try it |
| LIKE | Search for a pattern | Try it |
| IN | To specify multiple possible values for a column | Try it |
Practice Excercise Practice now