SELECT: SUBSTR

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

const query = myQueryBuilder
    .SELECT({ $SUBSTR: 'field', $ARGS: [2] })
    .from('table')
    .get();

// SELECT SUBSTR(`field`, 2) FROM `table`

const query = myQueryBuilder
    .SELECT({ $SUBSTR: 'field', $ARGS: [2, 10] })
    .from('table')
    .get();

// SELECT SUBSTR(`field`, 2, 10) FROM `table`

const query = myQueryBuilder
    .SELECT({ $SUBSTR: { field: 'fieldSUBSTR' }, $ARGS: [2] })
    .from('table')
    .get();

// SELECT SUBSTR(`field`, 2) AS `fieldSUBSTR` FROM `table`

const query = myQueryBuilder
    .SELECT({ $SUBSTR: { field: 'fieldSUBSTR' }, $ARGS: [2, 10] })
    .from('table')
    .get();

// SELECT SUBSTR(`field`, 2, 10) AS `fieldSUBSTR` FROM `table`