WHERE: LTE

Jump to bottom

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

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

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

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

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

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

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