SELECT: LOWER

Jump to bottom

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

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

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

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

// SELECT LOWER(`field`) AS `fieldLOWER` FROM `table`