how to query mongodb with like

db.users.find({"name": /.*m.*/});

db.users.find({"name": /m/});

Items.find({"description": {$regex: ".*" + variable + ".*"}}).fetch();

4.22
13
Nadeem 130 points

                                    db.users.find({"name": /m/})
or
db.users.find({"name": /.*m.*/})

You're looking for something that contains "m" somewhere
(SQL's '%' operator is equivalent to Regexp's '.*'), 
not something that has "m" anchored to the beginning of the string.

4.22 (9 Votes)
0
3.67
6

                                    db.users.find({"name": /m/})

3.67 (6 Votes)
0
4
8
Ilya 115 points

                                    db.collection.find( { "url": { "$regex": ".*a.*"} } );

4 (8 Votes)
0
Are there any code examples left?
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
mongoid like query mongodb find document like with or condition mongodb find document like how to use mongodb like sql mongodb find where like mongodb 'like' mongodb query for like like data.sql for mongodb like data.sql für mongodb js mongodb like find name like a mongodb find text like in mongodb find text like in mongo mongodb like string like command in mongo where like mongodb mongodb match using like in string mongodb filter like like in mongo query like condition in mongodb mongodb search query like search like mongodb mongodb like query tutorial is mongodb like sql mongo query like with right mongodb find like go mongodb find like name like querry in mongodb how to search like in mongodb collection name like in mongodb where like in mongodb mongodb query something like mongodb field like Mongodb match like mongodb find query like string mongo where string like query search mongodb like sql Like system mongodb like operation in mongodb is mongo db like sql other db like mongodb how to use like in mongodb mongodb like condition mongo db like command like query in mongo mongodb like where mongodb like equivalent string like query in mongodb string like query in mongo like search mongodb how to do contains like search in mongodb mongodb like query example sql like operations in mongodb how to query like in mongodb sql like in mongo like and or condition in mongodb like query mongo db like command in mongodb how to write like query in mongodb like condition mongodb how to apply like in mongodb the like operator in mongodb query.$or like mongo like equivalent in mongodb how to query mongodb with like mongodb recherche like equivalent of like in mongodb mongodb query to find like mongodb find one like like query mongodb find like in mongodb mongodb query find(like) like clause in mongodb mongodb like db mongo db find like find like mongodb mongo search string like sql like operator in mongodb mongodb find wildcard mongodb client find like mongodb search like a field search mongodb like mongo find with like sql like mongo like mongodb find mongodb query like similar find mongo like sql like sql mongo How to query MongoDB with “like”? mongodb find similar like statement in mongodb regex like operator mongodb $search mongodb like operator mongodb find like string mongodb tolerant string search like operator like find mongodb how to perform a like statement in mongodb mongodb find like query like query in mongodv ilike mongodb filter mangodb query for wild card search mongodb search partial string mongo search like like operator mongodb mongodb find by name like mongo find wildcard search mongi find wilcard search query like in mongodb query mongodb like how do u do a like query in nosql mongodb getcollection like command how to find in mangodb like query mongo query equivalent to like name like mongodb mongodb query wildcard mongodb + like mongodb shell like like mongodb query mongodb find starts with like no mongodb sql like in mongodb mongodb string like filter mongodb filter query like mongo compass like pymongo query like find name like mongodb mongo query like mongodb like start with mongodb like example mongodb like search as operator like in mongodb as like in mongodb mongodb starting with a string search mongodb find wildcard value mongodb likes "like" in mongodb mongodb string like like in mongodb compass fine mongodb like text is mongodb sql like query like mongodb how to search like in mongs how to search like in mongodb find like mongo commande in mongo to filter names that start with something mongodb find partial string mongodb select like SQL LIKE statement for mongo how to match part of string from query params in mongodb get data which start with specific string mongodb mongo string like search mongo like() mongo find like mongo findOne where like match wildcard mongodb property mongodb compass query like how to use like query in Mongodb compass namr like in mongodb mongo like query mongo db shell like command like function in mongodb mongodb compass filter name startswith mongodb $like to search a text mongodb equivalent of like sql like operator mongobd $like in mongodb mongo query wildcard mongodb get like mongodb find string like mongodb compass search like mongodb like or mongodb like operator mongodb search wildcard mongo like expression findone where condition like mongodb mongodb aggregate like mongodb search string like query mongodb with like like in mongodb contains in robo 3t query how to use like query in pymongo like tyoe query in mongodb mongodb find where field like mongodb query like condition like query in mongodb mongodb search like like operator in mongodb like regex mongodb mongodb query like like in mongodb query search mongodb partial string mongo like mongodb find like like search in mongodb mongodb where like mongodb like query mongodb like how to query like record in mongodb where to use mongodb mongodb like statement mongodb query like sql like mongodb
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source