AGGREGATE Movie tutorial: Difference between revisions
From NoSQLZoo
| Line 20: | Line 20: | ||
==John Hurt in Harry Potter== | ==John Hurt in Harry Potter== | ||
<div class=q data-lang="mongo"> | <div class=q data-lang="mongo"> | ||
List the Harry Potter movies that feature John Hurt. | |||
<pre class=def> | <pre class=def> | ||
</pre> | </pre> | ||
Latest revision as of 22:16, 11 May 2017
Alien
Use aggregate to show details of the movie "Alien"
db.movies.aggregate([
{$match:{
title:"Alien"
}}
])
db.movie.aggregate([
{$match:{
title:"Alien"
}}
])
John Hurt in Harry Potter
List the Harry Potter movies that feature John Hurt.
db.movies.aggregate([
{$match:{
cast:"John Hurt"
}},
{$match:{title:{$regex:'Harry Potter'}}},
{$project:{title:1,_id:0}}
]).pretty()