Mysql Logical Operators

Topic

What are the Logical Operators In MySQL ?

Explanation

MySQL Logical Operators :


MySQL supports the following logical operations :
Lets we see the Logical Operators in MySQL.
MySQL AND(&&) Operator :
The logical AND(&&) operator indicates whether the both operands are true. Lets see a statement using AND operator.
Mysql Logical Operators
In the above example it will list the studid and name of the student who have secured more than 80 and less than 100.
MySQL OR(||) Operator :
The logical OR(||) operator indicates whether either operand is true. Lets see a statement using OR operator.
Mysql Logical Operators
In the above statement it will list the name, marks and address of the student whose name starts with the letter A and S.
MySQL NOT(!) Operator :
The logical NOT(!) operator have only one operand and it returns the inverse of the value.
Mysql Logical Operators
It will list all the student details except the studid 1.
The above description defines the MySQL Logical Operators and their Uses.