These operators are generally used in SQL like with WHERE clause. You can use any one operator or any number of operators (Unless it is logically and Syntax Correct)
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 |