Database

[{firstName:"John",lastName:"Smith",data:"today"},{firstName:"Alice",lastName:"Johnson",data:"yesterday"},{firstName:"Bob",lastName:"Williams",data:"tomorrow"},]

Query

db.collection.aggregate([{$project:{"name":{$concat:["$firstName"," ","$lastName"]},firstName:1,lastName:1,data:1}},{$match:{"name":{"$regex":"ohn","$options":"i"}}},{$project:{firstName:1,lastName:1,data:1}}])

Result