SQL operators are used to specify comparisons between expressions.
Operator | Description |
---|---|
BETWEEN |
Determines if a value is between two non-inclusive bounds. For example:
|
IN |
Determines if a value is present in a set of values. For example:
|
IS NULL |
Determines if a value is null. For example:
|
LIKE |
Determines if a value matches all or part of a string. Often used with wildcard characters to indicate any character string match of zero or more characters (%) or a any single character match (_). For example:
|