WHERE: GTE

Jump to bottom

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

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

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

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

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

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

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