NotBetween
Negated range comparison (left not between right[0] and right[1]). Extends
Between. Shorthand keys: notBetween, nbtw, !between, !btw.
Constructor
NotBetween(left: string | SqlElement, right: any[] | SqlElement): NotBetween
NotBetween(left: string | SqlElement, right1: any, right2: any): NotBetween
new NotBetween(...): NotBetween
Dual-callable, same two argument forms as Between.
import { NotBetween, Select } from '@sqb/builder';
Select().from('customers').where(NotBetween('id', 10, 20));
// where id not between 10 and 20
Properties
Inherits every property from Between (_type, _left, _right, _symbol,
_isArray); _symbol is always 'not between'.
Methods
Inherits ._serialize() from Between; NotBetween
adds no methods of its own.
Object-literal shorthand
Select().from('customers').where({ 'id !between': [10, 20], 'age notBetween': [18, 30] });
// where id not between 10 and 20 and age not between 18 and 30