Overview
SQLite Comparison operators are used to compare two values, database columns or expressions, to determine their relationship. These operators are commonly used in the WHERE clause to make decisions and display the query results based on the comparisons.
SQLite Comparison Operators
SQLite comparison operators are as follows in a table format:
| SQLite Comparison Operator |
Name | Description |
| == = |
Equals to Operator | This operator checks if the values of two operands are equal; if yes, it returns 1, and the condition becomes true. Otherwise, it returns 0 |
| !=
<> |
Not Equals to Operator | This operator checks if the values of two operands are not equal; if the values are not equal, the condition becomes true. |
| < | Less Than Operator | This operator checks if the value of the left operand is less than that of the right-hand operand; if yes, the condition becomes true. |
| > | Greater Than Operator | This operator checks if the value of the left operand is greater than that of the right-hand operand; if yes, the condition becomes true. |
| <= | Less Than or Equal to Operator | This operator checks if the value of the left-hand operand is less than or equal to that of the right-hand operand; if yes, the condition becomes true. |
| >= | Greater Than or Equal to Operator | This operator checks if the value of the left-hand operand is greater than or equal to that of the right-hand operand; if yes, the condition becomes true. |
| !< | Not Less Than Operator | This operator checks if the value of the left-hand operand is not less than that of the right-hand operand; if yes, the condition becomes true. |
| !> | Not Greater than Operator | This operator checks if the value of the left-hand operand is not greater than that of the right-hand operand; if yes, the condition becomes true. |
—
SQLite Tutorials
SQLite tutorials on this website:
https://www.testingdocs.com/sqlite-database-tutorials/
For more information on SQLite, visit the official website: