support for IN SQL statement

[guruyaya]

To be honest I was sure pydal has one. I cannot find it, so - i guess it's not in
I miss the option to use IN statement in queries. For example

SELECT `table`.`name` FROM `table` WHERE `id` IN ('1', '2', '3')

I'd imaging the syntax going something like this:

db(db.table.id.isin([1,2,3])).select(db.table.name)

[mdipierro]

The syntax is field.belongs([1,2,3])

…

On Sun, May 9, 2021, 09:01 guruyaya ***@***.***> wrote: To be honest I was sure pydal has one. I cannot find it, so - i guess it's not in I miss the option to use IN statement in queries. For example SELECT `table`.`name` FROM `table` WHERE `id` IN ('1', '2', '3') I'd imaging the syntax going something like this: db(db.table.id.isin([1,2,3])).select(db.table.name) — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#659>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAHLZT45POB75GLGCO3DTW3TM2IVDANCNFSM44PD3KRQ> .