WHERE: :

Jump to bottom

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

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

// SELECT * FROM `table` WHERE ((`field` = 'value'))

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

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

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

// SELECT * FROM `table` WHERE (ISNULL(`field`))

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

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