SQL operators are used to specify comparisons between expressions.
You can use various types of SQL operators.
Operator | Description |
---|---|
|
Determines if a value is between two non-inclusive bounds. For example:
|
|
Determines if a value is present in a set of values. For example:
|
|
Determines if a value is null. For example:
|
|
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 any single character match (_). For example:
|