About this question
I want to query something with SQL's like the query:
SELECT * FROM users WHERE name LIKE '%m%'How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.
I want to query something with SQL's like the query:
SELECT * FROM users WHERE name LIKE '%m%'How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask Salesforce Expert
Answered on Jul 15, 2021
You can use something like as follows:
db.users.find({"name": /.*m.*/})
or, similar:
db.users.find({"name": /m/})Note: You can use a SQL LIKE statement in MongoDB with the find command and search for word similarities using regex on your MongoDB database.
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step Salesforce guides from industry experts
Common Salesforce interview questions, answered
Guides, tips and career advice on Salesforce from JanBask experts.
Salesforce How to Become a Salesforce Developer Without Experience
No coding background? Learn how to become a Salesforce Developer step by step - skills to build, projects to create, and how to…
Salesforce How to Become a Salesforce Admin With No Experience
No Salesforce Admin experience? Learn how to build real skills, create projects, and land an entry-level Salesforce Admin job…
Salesforce How Long Does It Take to Become a Salesforce Developer?
Wondering how long to learn Salesforce Developer? Most beginners need 6–12 months. See the study time, stage-by-stage roadmap and…
Salesforce How Long Does It Take to Become a Salesforce Admin?
Wondering how long to learn Salesforce Admin? Most beginners need 3–6 months. See the study time, stage-by-stage roadmap and…