<转>MongoDB 查询语句 博客分类： NoSQL mongodb语句

---查询语句---

 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

 db.users.find({'age':{$lt:33}})

 条件查询

 select * from users where age>33 and age<=40

 db.users.find({'age':{$gt:33,$lte:40}})

 条件查询

 select * from users where a=1 and b='q'

 db.users.find({a:1,b:'q'})

 条件查询

 select * from users where a=1 or b=2

 db.users.find( { $or : [ { a : 1 } , { b : 2 } ] } )

 条件查询

 select * from users limit 1

 db.users.findOne()

 条件查询

 select * from users where name like "%Joe%"

 db.users.find({name:/Joe/})

 模糊查询

 select * from users where name like "Joe%"

 db.users.find({name:/^Joe/})