Where IN clause in Ormlite


Is there a way to do queries like the below in ormlite

SELECT * FROM table where wid = 1 AND cid IN (1,2,3,4,5,6)

I know how to do it by writing the raw SQL obviously so I m looking for a different way that uses my mappings.


Here is the sample from OrmLite documentation how to use IN clause

db.Select<Author>(x => Sql.In(x.City, "London", "Madrid", "Berlin"));
1 Like

Thanks - Not sure how I missed that.