WHERE: GT

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

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

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

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

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

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

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