Difference between revisions of "AGGREGATE Movie tutorial"
From NoSQLZoo
(→Alien) |
|||
| 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 23: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()