or operator in mongodb

Question

I have some data like this :

db.movies.insert([
    {
        title : "Fight Club",
        writer : "Chuck Palahniuk",
        year : 1999,
        actors : [
          "Brad Pitt",
          "Edward Norton",
        ]
    },
    {
        title : "Pulp Fiction",
        writer : "Quentin Tarantino",
        year : 1994,
        actors : [
          "John Travolta",
          "Uma Thurman",
        ]
    },
    {
        title : "Inglorious Basterds",
        writer : "Quentin Tarantino",
        year : 2009,
        actors : [
          "Brad Pitt",
          "Diane Kruger",
          "Eli Roth",
        ]
    },
    {
        title : "The Hobbit: An Unexpected Journey",
        writer : "J.R.R. Tolkein",
        year : 2012,
        franchise : "The Hobbit",
    },
    {
        title : "The Hobbit: The Desolation of Smaug",
        writer : "J.R.R. Tolkein",
        year : 2013,
        franchise : "The Hobbit",
    },
    {
        title : "The Hobbit: The Battle of the Five Armies",
        writer : "J.R.R. Tolkein",
        year : 2012,
        franchise : "The Hobbit",
        synopsis : "Bilbo and Company are forced to engage in a war against an array of combatants and keep the Lonely Mountain from falling into the hands of a rising darkness.",
    },
    {
        title : "Pee Wee Herman's Big Adventure"
    },
    {
        title : "Avatar"
    }
])

I need to get all movies released before the year 2000 or after 2010, So I'm writing this query:

db.movies.find( {$or: [{"year" : {$gt:2010,$lt:2000}}]})

But I'm not getting any output. Please suggest.

it's not possible to have a year greater than 2010 and less than 2000. — okzoomer
– okzoomer, Commented Aug 9, 2021 at 13:41

Tamilselvan Subramani · Accepted Answer · 2021-08-09 15:00:43Z

1

To insert multiple data use db.movies.insertMany([]) option.

to achieve this you can try it like this

db.movies.find({ $or: [{ "year": { $gt: 2010 } }, { "year": { $gt: 2000 } }] })

you can check this for proper documentation here https://docs.mongodb.com/manual/reference/operator/query/or/

answered Aug 9, 2021 at 15:00

Tamilselvan Subramani

535 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

or operator in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related