MongoDB 查询带有排除的数组字段[重复]

使用MongoDB查询带有排除的数组字段

db.users.find({
  $and: [
    { interests: "阅读" },
    { interests: "旅行" },
    { interests: { $nin: ["电影"] } }
  ]
})

npm install mongoose

javascript
const mongoose = require('mongoose');
mongoose.connect('mongodb://localhost:27017/mydatabase', { useNewUrlParser: true });
const userSchema = new mongoose.Schema({
  interests: [String]
});
const User = mongoose.model('User', userSchema);
User.find({
  $and: [
    { interests: "阅读" },
    { interests: "旅行" },
    { interests: { $nin: ["电影"] } }
  ]
}, (err, users) => {
  if (err) {
    console.error(err);
  } else {
    console.log(users);
  }
});