In MySQL there are multiple comparison operators. These symbols are = >= <= != > <
There are more comparison operators which are not like symbols, we will discuss further.
To understand this we take a common table ‘employee’ and we will perform several operations of comparison operators.
(greater-than operator)
Syntax – SELECT attribute_names FROM employee WHERE condition;
(less-than operator)
Syntax – SELECT attribute_names FROM employee WHERE condition;
Equal(=) operator
Syntax – SELECT attribute_names FROM employee WHERE filed=?;
Greater-than equal(>=) operator
Syntax – SELECT attribute_names FROM employee WHERE filed>=?;
Less-than equal(<=) operator
Syntax – SELECT attribute_names FROM employee WHERE filed<=?;
NOT EQUALS operator
Syntax – SELECT * FROM table_name WHERE !=?;
