mongo简单使用

Mongo查询

# 普通

{"typeTags.child.child.tagName":"坠楼事故"}

{"typeTags.0.child.0.child.0.tagName":"坠楼事故"}

{"$or":[{"typeTags.child.child.tagName":"羊楼洞传奇沉浸式电影"}, {"recommendDescTags.tagName":"羊楼洞传奇沉浸式电影"}]}

# 存在

{"148":{"$exists":true}}

# 个数

{favorite_number: {$size: 3}}

# 大小于

{"releaseTime":{ $gt:ISODate("2019-10-07T00:00:00Z")}}

db.collection.find({ "field" : { $gt: value } } ); // greater than : field > value
db.collection.find({ "field" : { $lt: value } } ); // less than : field < value
db.collection.find({ "field" : { $gte: value } } ); // greater than or equal to : field >= value
db.collection.find({ "field" : { $lte: value } } ); // less than or equal to : field <= value

# 包含

{badges:"black"}list包含

"_id":{"$in": newsid}

# 字符长度

"typeTags.child.child.tagName": {"$regex": /^.{1,1}$/}

 

# distinct

db.channel_recommend_history.distinct("itemId")

 

# 聚合

db.memberApiVisitLog.aggregate(
[ { "$match" : {
"userId": {"$gt":0},
"createTime":{$gt:"2019-11-12 00:00:00"}
}}