WHERE: LT

Jump to bottom

Ali Amirnezhad edited this page Jul 24, 2019 · 1 revision

const query = myQueryBuilder
    .SELECT()
    .from('table')
    .where({ field: { $LT: 2 } })
    .get();

// SELECT * FROM `table` WHERE ((`field` < 2))

const query = myQueryBuilder
    .SELECT()
    .from('table')
    .where({ field: { $LT: new Date() } })
    .get();

// SELECT * FROM `table` WHERE ((`field` < '1979-06-03 01:23:45'))

const query = myQueryBuilder
    .SELECT()
    .from('table')
    .where({ field: { $LT: { $DATE: new Date() } } })
    .get();

// SELECT * FROM `table` WHERE ((`field` < '1979-06-03'))