Displaying values for which two column fields have different values

1

I am basically trying to compare 2 columns of one table and want to display values which does not have same/like values for these two columns.

I wanted to use ‘Not Like’ phenomenon here.
How do we do that?
How do we place column name in like phrase?

I tried following but it doesn’t work.

Field1! =~ /field2/

2

Can you provide some more info? I’d love to see an example query and output so I can better understand what you need.