How to perform SQL "IN" query

[Pawan Kumar]

Hi,

Can somebody point in the direction where I can see how to use below query?

select * from table_t where id in (4,7,9,10)

Thanks
Pawan

[virtualeyes]

use inSet.

val ids = List(1,2,3)
for{o <- YourTableObject if o.id inSet ids } yield(o)

[Pawan Kumar]

Thanks, it worked.

Pawan