SQL vs NOSQL (MongoDB) Queries

 http://docs.mongodb.org/manual/reference/sql-comparison/
http://www.hacksparrow.com/the-mongodb-tutorial.html

string comparison
db.records.find( { "endDate": { $gt: "2015-05-01T00:00:00" ,$lt: "2015-05-18T00:00:00" } } )

ssh -i ~/.ssh/aws.pem ubuntu@10.199.2.187
mongo
use portello
rs status()
show collections
db.Card.count()
db.Card.remove()
db.User.find().pretty()
db.Card.find({'parentId':123}).pretty()

db.User.find({'userId':123}).pretty()

db.Course.find({title:{$regex: /PERF/ }})

db.Course.find({"courseCallNo": {$in : ["123456"]}})

/opt/mongodb/mongodb/bin/mongo localhost:27017/portello -u app_user  -p 123@123

ps -ef | grep mongo