MySQL NOT Operator is one of the Logical Operator which is used in the WHERE Clause to apply filters on the rows returned by SELECT Statement. This operator returns the result as:
- 1, if the operand is zero
- 0, if the operand is 1.
- NULL, If the operand is NULL.
In this article we will show you, How to use the MySQL Logical Operator NOT in WHERE Clause to filter the data. In order to explain the NOT operator, we are going to use the below shown data.
MySQL NOT Operator – Command prompt
In this example we will pass Zeros, Ones, and Null values with different combination. This example helps you to understand the Truth table behind the NOT Operator.
|
1 2 3 4 5 6 7 8 9 10 11 |
-- NOT Operator in MySQL Example SELECT NOT 1; SELECT NOT 0; SELECT NOT NULL; SELECT !1; SELECT !(1 - 1); |
OUTPUT
MySQL NOT Operator Example
In MySQL, NOT Operator is used to test user specified condition in WHERE Clause.
|
1 2 3 4 5 6 7 8 |
-- MySQL NOT Operator Example USE company; SELECT CustID, First_Name, Last_Name, Education, Profession, Yearly_Income, Sales FROM customers WHERE Education != 'High School'; |
OUTPUT
Thank You for Visiting Our Blog
Share your Feedback, or Code!!