Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    MySQL NOT IN

    Uploaded by

    ahmed

    Copyright:

    © All Rights Reserved
    Download as PDF or read online from Scribd

    MySQL NOT IN

    Uploaded by

    ahmed
    14 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF or read online from Scribd
    Download as pdf
    14 views3 pages

    MySQL NOT IN

    Uploaded by

    ahmed

    Copyright:

    © All Rights Reserved
    Download as PDF or read online from Scribd
    Download as pdf
    of 3
    9116123, 158 AM MySal. NOTIN IW mysqutuTorIAL MySQL NOT IN Summary: in this tutorial, you'll learn how to use the MySQL Nor IN operator to check if a value is not in a list of values. Introduction to the MySQL NOT IN operator The NoT operator negates the IN (hetps://um.nysaltutorial.org/nysel-basics/aysql-in/) operator: The Not N operator returns one if the value doesn’t equal any value in the list. Otherwise, it returns 0. The following example uses the ot IN operator to check if the number 1 is Not rN the list (1,2,3): SELECT 1 NOT IN (1,2,3 Output: ra + | 1 NoT IN (1,2,3) | 1 row in set (0.00 sec) It returns 0 (false) because 1 is not 1n thelistis false The following example uses the NoT IN operator to check if 0 is oT IN the list (1,2,3) SELECT @ NOT IN (1,2,3 Output: tps hwo mysatutorial orgimysql-basiesimysqhnatin’ 1 9116123, 158 AM MySal. NOTIN | @ Nor IN (1,2,3) | + 1 row in set (0.00 sec) The NoT IN operator returns NULL (https//www.mysqltutorialorg/mysal-null) if the value on the left side of the IN operator is NULL. For example: SELECT NULL NOT IN (1,2,3 Output: | NULL NOT IN (2,2,3) | 1 row in set (8.60 sec) Technically, the NoT IN. operator is equivalent to the following Or: MySQL NOT IN operator example We'll use the offices table from the sample database to illustrates the Not IN operator: tps hwo mysatutorial orgimysql-basiesimysqhnatin’ 28 9116123, 158 AM MySal. NOTIN The following example uses the NoT IN operator to find the offices that do not locate in. France and the USA : SELECT FROM WHERE NOT IN (*USA’ ORDER BY | officecode | city | phone 17 | London | +44 20 7877 2041 l6 | Sydney | +61 2 9264 2452 [5 | Tokyo | +81 33 224 Se00 3 rows in set (0.02 sec) Summary * Use the MySQL or IN to check if a value doesn’t match any value in a list tps hwo mysatutorial orgimysql-basiesimysqhnatin’

    You might also like