|
Operator
|
Meaning
|
|
=
|
Equal to
|
|
>
|
Greater than
|
|
>=
|
Greater than or equal to
|
|
<
|
Less than
|
|
<=
|
Less than or equal to
|
|
<>
|
Not equal to
|
|
BETWEEN
...AND... |
Between two values (inclusive)
|
|
IN(set)
|
Match any of a list of values
|
|
LIKE
|
Match a character pattern
|
|
IS NULL
|
Is a null value
|
No comments:
Post a Comment