Mysql Logical Operators

MySQL Logical Operators :

MySQL supports the following logical operations :

• AND(&&) Operator
• OR(||) Operator
• NOT(!) Operator

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. 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. 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. It will list all the student details except the studid 1.
The above description defines the MySQL Logical Operators and their Uses.