Prisma: how to use IN with two params in queryRaw? - Stack Overflow

Documentation says:const ids = [1, 3, 5, 10, 20];const result = await prisma.$queryRaw`SELECT * FROM

Documentation says:

const ids = [1, 3, 5, 10, 20];
const result = await prisma.$queryRaw`SELECT * FROM User WHERE id IN (${Prisma.join(ids)})`;

It works. But how to follow this way with two params in IN?

SQL for example:

SELECT * FROM table WHERE (param1, param2) IN (('str1', 'str2'), ('str3', 'str4'));

Thanks.

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1742407388a4438128.html

相关推荐

  • Prisma: how to use IN with two params in queryRaw? - Stack Overflow

    Documentation says:const ids = [1, 3, 5, 10, 20];const result = await prisma.$queryRaw`SELECT * FROM

    3小时前
    20

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信