MySQL Comparison
From w3cyberlearnings
The Relational/Comparison Operators
- The comparison operators use in the Where clause to filter the return result.
Comparison Operators Description --------------------------------------------------- = Equal to <> or != Not Equal to < Less than <= Less than or equal to > greater >= greater or equal to LIKE use to compare string BETWEEN Check for a value between a range IN Check for a value in a list NOT IN Check for a value not in a list IS NULL Check for a value is null IS NOT NULL Check for a value is not null
