Have ideas to improve npm?Join in the discussion! »

sql-operators

0.0.7 • Public • Published

sql-operators

NPM

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

Keywords

Install

npm i sql-operators

DownloadsWeekly Downloads

7

Version

0.0.7

License

MIT

Last publish

Collaborators

  • avatar