Mongo语句find与update实战

//查询编码

db.t_iot_real_hours_data.find({"MN": "CEG22260097*"});

//精确查询，多条件

db.t_iot_real_hours_data.find({"MN":"JSYQ1032011600071000",F_a01001:{$ne:"N"},hours:{$gte:"2022-08-31 10",$lte:"2022-09-16 18"}});

//精确查询，多条件

db.t_iot_real_hours_data.find({"MN":"JSYQ1032011600071000",hours:{$gte:"2022-08-31 10",$lte:"2022-09-16 18"}});

//精确查询，多条件

db.t_iot_real_hours_data.find({"MN":"CEG22260097*",hours:{$gte:"2022-08-31 10",$lte:"2022-09-16 18"}});

//模糊查询，/类似sql匹配符%

db.t_iot_real_hours_data.find({MN:/CEG222/,hours:{$gte:"2022-08-31 10",$lte:"2022-09-16 18"}});

//根据时间段和数据特征，还原回去

db.t_iot_real_hours_data.update({"MN":"JSYQ1032011600071000",F_a01001:{$ne:"N"},hours:{$gte:"2022-08-31 10",$lte:"2022-09-16 18"}}, {$set: {

    "siteCode": "CEG22260097*",

    "MN": "CEG22260097*"}

},{

    multi: true

})

//修改编码

db.t_iot_real_hours_data.update({

    "MN": "CEG22260097*"

}, {$set: {

    "siteCode": "JSYQ1032011600071000",

    "MN": "JSYQ1032011600071000"}

},{

    multi: true

})