Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • MySQL: selecting rows where a column is null

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 615
    Comment on it

    In MySQL, we can select rows where a column is null by using IS NULL operator.

    We have a table "employee" as below:

       

     employee
    id first_name salary country
    .......................................................
    1  John       10000  Canada
    2  Chris      20000  NULL
    3  Max        30000  NULL
    4  Jenny      25000  Canada

    Use the IS NULL operator

    The below statement selects all employee where "country" is null:

       

        SELECT * FROM employee
    WHERE country is null;

    Result

      

      id first_name salary country
  .......................................................
  2  Chris      20000  NULL
  3  Max        30000  NULL

    Hope this will help you :)

    mysql database is null operator
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: