select where not like
Closed this issue · 3 comments
AuspeXeu commented
Is there a way to negate the like/ilike operator?
select * from table where name is not like 'bob%';
martijndeh commented
Would something like this work?
db.select(star()).from(db.table).where(not(db.table.name.like('bob%'));
AuspeXeu commented
Either that or just a notLike
operator like we have it for notIn
which I would actually prefer.