# Mongo Drills

## Get all
```javascript
db.restaurants.find()
```

## Limit and Sort
```javascript
db.restaurents.find().sort({name:1}).limit(10)
```

## Get by \_id
```javascript
var itemId = db.restaurants.findOne()._id;
db.restaurants.find({_id: itemId})
```

## Get by value
```javascript
db.restaurants.find({borough: "Queens"})
```

## Count
```javascript
db.restaurants.count()
```

## Count by nested value
```javascript
db.restaurants.find({"address.zipcode": "11206"}).count()
```

## Update a single document
```javascript
var itemId = db.restaurants.findOne()._id;
db.restaurants.updateOne(
  {_id: itemId},
  {$set: {name: "Bizz Bar Bang"}}
 );

 // to see changes
 db.restaurants.find({_id: itemID})
 ```

 ## Update many documents
 ```javascript
 db.restaurants.update(
  {"address.zipcode": "10035"},
  {$set: {"address.zipcode": "10036"}},
  {multi: true})

// to show there are no more, .count() should return 0
db.restaurants.find({"address.zipcode": "10035"}).count()
 ```