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