How to retrieve the documents whose values ending with a particular character in mongoDB

mongodb mongo-shell
Nithin K Anil picture Nithin K Anil · Feb 28, 2013 · Viewed 10.5k times · Source

I inserted the documents into a particular database in mongoDB. for example 

 db.employee.insert({name:"nithin",age:22})
 db.employee.insert({name:"sreedevi",age:32})

now i wnat to retrive the documents whose name ending with character 'i'.

Answer

Sushant Gupta picture Sushant Gupta · Feb 28, 2013

In Javascript shell, use $regex operator

db.employee.find({name: {$regex: "i$"}})

Related questions

How can I list all collections in the MongoDB shell?

In the MongoDB shell, how do I list all collections for the current database that I'm using?

Read More
how can I connect to a remote mongo server from Mac OS terminal

I would like to drop into the mongo shell in the terminal on my MacBook. However, I'm interested in connecting to a Mongo instance that is running in the cloud (compose.io instance via Heroku addon). I have the name, …

Read More
Pretty print in MongoDB shell as default

Is there a way to tell Mongo to pretty print output? Currently, everything is output to a single line and it's difficult to read, especially with nested arrays and documents.

Read More