NotILike
Negated case-insensitive pattern-matching comparison (left not ilike right). Extends
ILike. Shorthand keys: notILike, nilike, !ilike. Exported from
not-i-like.ts as NotILike.
Constructor
NotILike(left: string | SqlElement, right?: string | SqlElement): NotILike
new NotILike(left: string | SqlElement, right?: string | SqlElement): NotILike
Dual-callable, same argument shape as Like.
import { NotILike, Select } from '@sqb/builder';
Select().from('customers').where(NotILike('name', 'john%'));
// where name not ilike 'john%'
Properties
Inherits every property from ILike (_type, _left, _right, _symbol,
_isArray); _symbol is always 'not ilike'.
Methods
Inherits .__serialize() from Like (via ILike); NotILike
adds no methods of its own.
Object-literal shorthand
Select().from('customers').where({ 'name !ilike': 'john%' });
// where name not ilike 'john%'