SELECT: UPPER

Jump to bottom

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

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

// SELECT UPPER(`field`) FROM `table`

const query = myQueryBuilder
    .SELECT({ $UPPER: { field: 'fieldUPPER' } })
    .from('table')
    .get();

// SELECT UPPER(`field`) AS `fieldUPPER` FROM `table`