Computer scienceFundamentalsSQL and DatabasesDBMSMongoDBOperations and operators

Regex in MongoDB

Mongo DB regex search

Report a typo

Choose the correct line of code that searches for all the wines with an id that starts with a small letter c from the collection Wines below:

[
  {       
    "id": "chard23",
    "name" : "Chardonnay ",
    "region" : "Toskana",
    "description" : "strong flavour with blueberry strings and smokey aroma"
  },
  {      
    "id": "shrz89",
    "name" : "Shiraz",
    "region" : "Australia",
    "description" : "old and full-bodied, with aromatic notes of smoke, black fruit and pepper spice."
  },
  {      
    "id": "svng23",
    "name" : "Sauvignon",
    "region" : "France",
    "description" : "flavor characteristics range from green herbaceous notes to ripe stone fruits.",
  },
  {
    "id": "cbrnt56",
    "name" : "Cabernet",
    "region" : "france",
    "description" : " Aromas and notes of fresh picked blueberries. Semi-Sweet wine.",
  }
]

Select one or more options from the list

db.Wines.find( { id: /^c.*/ } ).pretty()

db.Wines.find( { id: { $regex: '^c.*'} } ).pretty()

db.Wines.find( { id: { $regex: 'c'} } ).pretty()

db.Wines.find( { id: { regex: 'c'} } ).pretty()

___

Create a free account to access the full topic