C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL NOT ConditionThe MySQL NOT condition is opposite of MySQL IN condition. It is used to negate a condition in a SELECT, INSERT, UPDATE or DELETE statement. Syntax:NOT condition Parametercondition: It specifies the conditions that you want to negate. MySQL NOT Operator with IN conditionConsider a table "officers", having the following data. Execute the following query: SELECT * FROM officers WHERE officer_name NOT IN ('Ajeet','Vimal','Deepika'); Output: MySQL NOT Operator with IS NULL condition:Execute the following query: SELECT * FROM officers WHERE officer_name IS NOT NULL; Output: MySQL NOT Operator with LIKE condition:We are taking the same table "officer" for this operation also: Execute the following query: SELECT * FROM officers WHERE officer_name NOT LIKE 'A%'; Output: MySQL NOT Operator with BETWEEN condition:We are taking the same table "officer" for this operation also: Execute the following query: SELECT * FROM officers WHERE officer_id NOT BETWEEN 3 AND 5; Output:
Next TopicMySQL Not Equal
|