Database

[{"Name":"Tom","MiddleName":"Tom"},{"Name":"Tom","MiddleName":"Tom1"}]

Query

db.collection.aggregate({$match:{$expr:{$eq:["$Name","$MiddleName"]}}})

Result

MongoDB version 8.0.16 - Report an issue - About this playground