Convert Sql Query into Mongodb Query

Question

I have one SQL query written below :

Select * from student where fname + ' ' + lname like '%abc mno%';

How to write the same query in MongoDB?

check this mongo sql mapping docs.mongodb.org/manual/reference/sql-comparison — Neo-coder
– Neo-coder, Commented Apr 7, 2015 at 13:35
This is an odd question, as presumably, your data in Mongo would be structured differently than in a relational database. — Mike Brant
– Mike Brant, Commented Apr 7, 2015 at 14:47

Vishwas · Accepted Answer · 2015-04-07 13:32:33Z

1

db.collection.find({"name":/.*abc mno.*/})

OR

db.collection.find({"name":/abc mno/})

You can also use mongo regex

db.collection.find({"name":{'$regex': 'abc mno'}})

answered Apr 7, 2015 at 13:27

Vishwas

7,0777 gold badges46 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Darshan Patel · Accepted Answer · 2018-11-21 06:24:23Z

0

Please find below examples,

db.student.find({name:{$regex:"a"}})  //Contain a anywhere

or

db.student.find({name:{$regex:"e$"}}) //Ends with e

or

db.student.find({name:{$regex:"^A"}}) //Start with A

answered Apr 7, 2015 at 15:44

Darshan Patel

2,9272 gold badges27 silver badges39 bronze badges