Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those restaurants which contain 'shop' as last three letters for its name.

Write a Query to find all the restaurants which contain 'shop' as the last three letters for its name.

Sample Document:

{ 
  "_id" : ObjectId("6029b6e30157be18e7ee4016"), 
  "address" : {
      "building" : "1007", 
      "coord" : [
          -73.856077, 
          40.848447
      ], 
      "street" : "Morris Park Ave", 
      "zipcode" : "10462"
  }, 
  "borough" : "Bronx", 
  "cuisine" : "Bakery", 
  "grades" : [
      {
          "date" : ISODate("2014-03-03T00:00:00.000+0000"), 
          "grade" : "A", 
          "score" : 2.0
      }, 
      {
          "date" : ISODate("2013-09-11T00:00:00.000+0000"), 
          "grade" : "A", 
          "score" : 6.0
      }, 
      {
          "date" : ISODate("2013-01-24T00:00:00.000+0000"), 
          "grade" : "A", 
          "score" : 10.0
      }, 
      {
          "date" : ISODate("2011-11-23T00:00:00.000+0000"), 
          "grade" : "A", 
          "score" : 9.0
      }, 
      {
          "date" : ISODate("2011-03-10T00:00:00.000+0000"), 
          "grade" : "B", 
          "score" : 14.0
      }
  ], 
  "name" : "Morris Park Bake Shop", 
  "restaurant_id" : "30075445"
}

Approach

Query: Query to find the restaurant name contains shop at last.

db.getCollection("Restaurants").find({name: /Shop$/},
{
"restaurant_id" : 1,
"name":1,"borough":1,
"cuisine" :1
});

Output: 

{ 
    "_id" : ObjectId("6029b6e30157be18e7ee4016"), 
    "borough" : "Bronx", 
    "cuisine" : "Bakery", 
    "name" : "Morris Park Bake Shop", 
    "restaurant_id" : "30075445"
}