SQL to MongoDB Converter

Online SQL to MongoDB Example

Below is an example of the original SQL to MongoDB and the result.

select id,salary from employee where age >= 35 and (designation = 'manager' or (lastname = 'Darshit' and firstname like '%Darshit%'))

And an example of how the online SQL to MongoDB works.

db.employee.find({

   "$and": [{
   "age ":{ "$gte" :  35  } 
    },{
   "$or": [{
    "designation " :  'manager' 
 },{
   "$and": [{
   "lastname " :  'Darshit' 
 },{ " firstname " :  '%Darshit%'
   }]
   }]
   }]
},{
   "id": 1,
   "salary": 1
}
);

How to use Yttags's SQL to MongoDB Converter?

• Step 1: Select the Tool

• Step 2: paste your SQL text into the textbox And Press The Convert Button And Check Your SQL to MongoDB Converter Result