0.0.7 • Published 8 years ago
sql-operators
Defines the list of operators in SQL as an array in Node.js.
var sqlOperators = require('sql-operators');
sqlOperators.has('LIKE'); // true
sqlOperators.has('JOKER'); // false
Arithmetic operators
| Operator | Description |
|---|
+ | Add |
- | Subtract |
* | Multiply |
/ | Divide |
% | Modulo |
Bitwise operators
| Operator | Description |
|---|
& | Bitwise AND |
| | | Bitwise OR |
^ | Bitwise exclusive OR |
Comparison operators
| Operator | Description |
|---|
= | Equal to |
> | Greater than |
< | Less than |
>= | Greater than or equal to |
<= | Less than or equal to |
<> | Not equal to |
Compound operators
| Operator | Description |
|---|
+= | Add equals |
-= | Subtract equals |
*= | Multiply equals |
/= | Divide equals |
%= | Modulo equals |
&= | Bitwise AND equals |
^= | Bitwise exclusive OR equals |
| |= | Bitwise OR equals |
Logical operators
| Operator | Description |
|---|
ALL | TRUE if all of the subquery values meet the condition |
AND | TRUE if all the conditions separated by AND is TRUE |
ANY | TRUE if any of the subquery values meet the condition |
BETWEEN | TRUE if the operand is within the range of comparisons |
EXISTS | TRUE if the subquery returns one or more records |
IN | TRUE if the operand is equal to one of a list of expressions |
LIKE | TRUE if the operand matches a pattern |
NOT | Displays a record if the condition(s) is NOT TRUE |
OR | TRUE if any of the conditions separated by OR is TRUE |
SOME | TRUE if any of the subquery values meet the condition |