SELECT: INSTR

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

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

// SELECT INSTR(`field`, 'search') FROM `table`

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

// SELECT INSTR(`field`, 'search') AS `fieldINSTR` FROM `table`