The meaning of the comparison operators such as NE and EQ

Compare all field types

To compare all field types, you can use the following operators in logical expressions:

< operators > Meanings

EQ equals

= equals

NE is not equal to

<> Not equal to

>< Not equal to

LT is less than

< less than

LE is less than or equal

<= less than or equal to

GT Greater than

> Greater than

GE is greater than or equal

>= greater than or equal to

The operand can be a database field, an inner field, a literal, or a constant.

Reference: http://m.blog.csdn.net/blog/fog911811/7713183

The meaning of the comparison operators such as NE and EQ