• 技术文章 >数据库 >MongoDB

    mongodb查询语句有哪些

    silencementsilencement2020-01-08 14:16:13原创2186

    如果觉得 Mongodb 语句不太好理解,可以和 SQL 语句进行对比,学起来要容易很多。

    查询(find)

    查询所有结果

    select * from article
    db.article.find()

    指定返回哪些键

    select title, author from article
    db.article.find({}, {"title": 1, "author": 1})

    where条件

    select * from article where title = "mongodb"
    db.article.find({"title": "mongodb"})

    and条件

    select * from article where title = "mongodb" and author = "god"
    db.article.find({"title": "mongodb", "author": "god"})

    or条件

    select * from article where title = "mongodb" or author = "god"
    db.article.find({"$or": [{"title": "mongodb"}, {"author": "god"}]})

    比较条件

    select * from article where read >= 100;
    db.article.find({"read": {"$gt": 100}})
    > $gt(>)、$gte(>=)、$lt(<)、$lte(<=)
     select * from article where read >= 100 and read <= 200
     db.article.find({"read": {"$gte": 100, "lte": 200}})

    in条件

    select * from article where author in ("a", "b", "c")
    db.article.find({"author": {"$in": ["a", "b", "c"]}})

    like

    select * from article where title like "%mongodb%"
    db.article.find({"title": /mongodb/})

    count

    select count(*) from article
    db.article.count()

    不等于

    select * from article where author != "a"
    db.article.find({ "author": { "$ne": "a" }})
    专题推荐:mongodb
    上一篇:mongodb在windows下怎么安装 下一篇:怎么在mongodb创建数据库

    相关文章推荐

    • mongodb有什么好处• mongodb是开源数据库吗• mongodb如何添加用户• mongodb怎么本地登录

    全部评论我要评论

    © 2021 Python学习网 苏ICP备2021003149号-1

  • 取消发布评论
  • 

    Python学习网