mongodb sql语句速成

inert into users value(3,5)
db.users.insert({a:3,b:5})

select a,b from users
db.users.find({}, {a:1,b:1})

select * from users
db.users.find()

select * from users where age=33
db.users.find({age:33})

select a,b from users where age=33
db.users.find({age:33}, {a:1,b:1})

select * from users where age=33 order by name
db.users.find({age:33}).sort({name:1})

select * from users where age>33
db.users.find({age:{$gt:33}})

select * from users where age!=33
db.users.find({age:{$ne:33}})

select * from users where name like "%Joe%"
db.users.find({name:/Joe/})

select * from users where name LIKE "Joe%"
db.users.find({name:/^Joe/})