MySQL Operators

Operator Meaning
= Equals
< Less than
> Greater than
<= Less than or equal to
>= Greater than or equal to
!== (also <>) Not equal to
IS NOT NULL Has a value
IS NULL Does not have a value
IS TRUE Has a true value
IS FALSE Has a false value
BETWEEN Within a range
NOT BETWEEN Outside of a range
IN Found within a list of values
NOT IN Not found within a list of values
OR (also ||) Where at least one of two conditionals is true
AND (also &&) Where both conditionals are true
Not (also !) Where the conditional is not true
XOR Where only one of the conditionals is true