Check if columns are different

HI, which query can I run to check if the values in one column are different from the values in another column? I tried {column1: {"$ne": column2}} but that gives everything, including equal and unequal values

You will need to use

1 Like