Database

[{name:"John",ipaddr:["1.1.1.1","2.2.2.2","3.3.3.3"],update:168450500},{name:"Eric",ipaddr:["1.1.1.1","4.4.4.4"],update:168450400},{name:"Tom",ipaddr:["3.3.3.3"],update:168450300}]

Query

db.collection.aggregate([{$match:{ipaddr:{$in:["1.1.1.1","4.4.4.4"]}}},{$set:{ipaddr:{$filter:{input:"$ipaddr",cond:{$in:["$$this",["1.1.1.1","4.4.4.4"]]}}}}},{$set:{ipaddr:{$last:"$ipaddr"}}}])

Result