[{"ownerName":"Bob","city":"Oregon","refNote":"sadkj1233233@qwertz"},{"ownerName":"Bob","city":"Oregon","refNote":"sadkj1233233@qwertz@abc"}]

db.collection.find({refNote:{$not:{$regex:"@qwertz$"}}})