search

kylefarris / node-querybuilder

Node QueryBuilder Adapter for Node.js (tags: nodejs, node, mysql, active record, activerecord, querybuilder, query builder)
49 stars 19 forks source link

How to get is null condition? #61

Closed vittoria-ravi closed 4 years ago

vittoria-ravi commented 4 years ago

Hi,

Can you please know how to get 'is null' condition in where statement.

Select departmentName, departmentSales From Department Where employeeLastName is null

vittoria-ravi commented 4 years ago

Got it ...

.where('employeeLastName IS NULL')