SQLite Comparison Operators

SQLite Comparison operators 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 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.