请问多列 in 查询怎么写

[Merena]

swift中，请问select * from aTable where (a,b) in (values (1,2),(3,4)) 中，where的部分怎么改成WINQ呢

[Qiuwen-chen]

It's not a valid sql for SQLite.

[Merena]

网上说sqlite支持这么写，而且在SQliteStudio里能执行成功

https://blog.csdn.net/mzl87/article/details/125723853

[Qiuwen-chen]

Indeed, it is not supported in Swift Winq yet. For now, you can convert it into multiple conditions.

[Merena]

OK，thank you.