iN method
IN Operator
Ex:
QueryBuilder.i
.selectAll()
.from('tableName')
.where()
.add('FirstName')
.iN(['Alex', 'John', 'Jacky'])
.build();
return
SELECT * FROM tableName WHERE FirstName IN ('Alex', 'John', 'Jacky');
Implementation
QueryBuilder iN(List values) {
values = values.map<dynamic>((dynamic e) {
if (_isNum(e)) {
return e;
}
return '\'$e\'';
}).toList();
return add('IN (${values.join(', ')})');
}