Comparing two fields without where operation

Working with Data
,
#1

This is my sample db
[
{
‘field1’:‘val1’,
‘field2’: ‘val1’
}
]

This has happened to a large number of my data. How can I compare the values of field1 and field2 of a document?

#2

You need to use the $expr syntax

1 Like