SQL Mapping

db.baseball.find(
{ colors: "white" }
)

db.baseball.find(
{ colors:
	{ $all: [ "orange", "black" ] }
}
)

Note: $all selects the documents where the field holds an 
array and contains all specified elements.

SELECT * FROM baseball
WHERE colors CONTAINS_ALL ('orange', 'black')

db.baseball.find(
{ colors:
	{ $all: [ "orange", "black" ],
	 $size: 2 }
}
)

Note: $size matches any array with the number of elements specified.

SELECT * FROM baseball
WHERE colors CONTAINS_ALL ('orange', 'black') AND
  ARRAY_SIZE(colors) = 2

or

db.baseball.find(
{ "stats.year":
	{ "$all": [ 2010, 2011 ] }
}
)

db.baseball.find(
{ stats:
	{ $elemMatch:
		{ wins: { $gt: 80 },
		 winPercentage: { $gt: 0.58 }
		}
	}
}
)

Note: $elemMatch matches more than one component within an array element.

db.baseball.find(
{ city:
	{ $in: [ "New York", "Chicago" ] }
}
)

Note: $in selects the documents where the field value 
equals any value in the specified list.

db.baseball.find(
{ worldChampionships:
	{ $exists: true, $gt: 10 }
}
)

Note: This query returns all documents where the 
worldChampionships field exists and its value > 10.

db.baseball.find(
{ worldChampionships:
	{ $exists: false }
}
)

Note: This query returns all documents that do 
not contain the worldChampionships field.

db.baseball.find( ... ).explain()

db.baseball.insert( {
	"teamName": "Dodgers",
	"city": "Los Angeles",
	"division":"NL",
	"managerName": { "first":"Joe", "last":"Torre" },
	"colors": [ "blue", "white" ],
	"worldChampionships": 6,
	"stats":
	[
		{
		"year":2010,
		"wins":80,
		"losses":82,
		"winPercentage":0.494
		},
		{
		"year":2011,
		"wins":82,
		"losses":79,
		"winPercentage":0
		},
		{
		"year":2012,
		"wins":0,
		"losses":0,
		"winPercentage":0
		}
	]
} )

db.baseball.update(
	{ "teamName": "Dodgers" },
	{ $set: {
		"ranking": 5,
		"division": "NL West",
		"managerName.first": "D",
		"managerName.last": "Mattingly"
		}
	},
	{ multi: true }
)

Note: The ranking field is added and the division 
and managerName fields are updated.

db.baseball.update(
	{ "teamName": "Dodgers" },
	{ $set: {
		"managerName": { "first": "Don", "last": "Mattingly" }
		}
	},
	{ multi: true }
)

db.baseball.update(
	{ "teamName": "Dodgers" },
	{ $set: { "worldChampionships": NULL } },
	{ multi: true }
)

db.baseball.update(
	{ "teamName": "Dodgers" },
	{ $unset: { "worldChampionships": 1 } },
	{ multi: true }
)

Note: To remove a field from matched documents only.

db.baseball.update(
	{ },
	{ $unset: { "worldChampionships": 1 } },
	{ multi: true }
)

Note: To remove a field from all documents in the collection.

db.baseball.update(
	{ "teamName": "Dodgers" },
	{ $set: { "colors": ["blue", "red"] } }
	{ multi: true }
)

db.baseball.update(
	{ "teamName": "Dodgers" },
	{ $set: { "colors.1": "gray" } }
	{ multi: true }
)

Note: The second element of the colors array field is updated.

db.baseball.update(
	{ "teamName": "Dodgers", "colors": "gray" },
	{ $set: { "colors.$": "white" } }
	{ multi: true }
)

Note: The matched element of the colors array field is updated.

db.baseball.update(
	{ "teamName": "Dodgers" },
	{ $push: { "colors": "black" } }
	{ multi: true }
)

Note: An element is added to the colors array field.

UPDATE baseball
SET colors[$] = 'black'
WHERE teamName = 'Dodgers'

or

UPDATE baseball
SET colors = colors + [ 'black' ]
WHERE teamName = 'Dodgers'

db.baseball.update(
	{ "teamName": "Dodgers" },
	{ $pull: { "colors": "black" } }
	{ multi: true }
)

Note: The matched element is removed from the colors array field.

UPDATE baseball
SET colors[$] = NULL
WHERE teamName = 'Dodgers' AND
 colors = 'black'

or

UPDATE baseball
SET colors = colors - [ 'black' ]
WHERE teamName = 'Dodgers'

db.baseball.update(
	{ "teamName":"Dodgers" },
	{ $pull: { "stats" : { "year" : 2012 } } }
	{ multi: true }
)

Note: The stats array entry that has year = 2012 is deleted.

db.baseball.update(
	{ "teamName":"Dodgers", "stats.year":2011 },
	{ $set: { "stats.$.winPercentage":0.509 } }
	{ multi: true }
)

db.baseball.update(
	{ "teamName": "Dodgers" },
	{
		$push: { "stats":
		{
		"year":2012,
		"wins":86,
		"losses":76,
		"winPercentage":0.531
		}
	}
)

Note: In this example, there is no search criteria for an existing 
stats array entry and therefore a new stats array entry is added.

db.baseball.update(
{ "teamName": "Dodgers" },
{ $set {
	"teamName":"Dodgers",
	"city":"Los Angeles",
	"division":"NL West",
	"ranking":5,
	"managerName": { "first":"Don", "last":"Mattingly" },
	"colors": [ "blue", "white" ],
	"worldChampionships": 6,
	"stats":
	[
		{
		"year":2010,
		"wins":80,
		"losses":82,
		"winPercentage":0.494
		},
		{
		"year":2011,
		"wins":82,
		"losses":79,
		"winPercentage":0.509
		},
		{
		"year":2012,
		"wins":86,
		"losses":76,
		"winPercentage":0.531
		}
	]
	}
}
{ upsert: true }
)

db.baseball.remove(
	{ "teamName": "Dodgers" },
)

db.baseball.remove()

db.baseball.drop()