Mongoose | where() Function

The where() function is used to create a Query, applies the passed conditions and returns the Query.

Installation of mongoose module:

  1. You can visit the link to Install mongoose module. You can install this package by using this command.
    npm install mongoose
  2. After installing mongoose module, you can check your mongoose version in command prompt using the command.
    npm version mongoose
  3. After that, you can create a folder and add a file, for example index.js. To run this file you need to run the following command.
    node index.js

Filename: index.js

  • filter_none

    edit
    close

    play_arrow

    link
    brightness_4
    code

    const mongoose = require('mongoose');
      
    // Database Connection
        useNewUrlParser: true,
        useCreateIndex: true,
        useUnifiedTopology: true
    });
      
    // User model
    const User = mongoose.model('User', {
        name: { type: String },
        age: { type: Number }
    });
      
    User.where('age').gte(5).lte(200)
            .exec(function (err, result) {
        if (err){
            console.log(err)
        }else{
            console.log("Result :", result) 
        }
    });

    chevron_right

    
    

Steps to run the program:

  1. The project structure will look like this:
  2. Make sure you have installed mongoose module using following command:
    npm install mongoose
  3. Below is the sample data in the database before the function is executed, You can use any GUI tool or terminal to see the database, like we have used Robo3T GUI tool as shown below:
  4. Run index.js file using below command:
    node index.js

So this is how you can use the mongoose where() function which creates a Query, applies the passed conditions, and returns the Query.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.