guys, how can I write such request - `SELECT * FRO...
# orm-helpm
Moe Green
03/02/2022, 6:23 PMguys, how can I write such request -
SELECT * FROM users WHERE email = '<mailto:ccc@gmail.com|ccc@gmail.com>' AND username = 'ccc'j
Johnson Detlev
03/02/2022, 6:24 PM Copy code
client.users.findMany({where: {email: '<mailto:ccc@gmail.com|ccc@gmail.com>', username: 'ccc'}})👀 1
m
Motdde
03/02/2022, 8:38 PMI’d probably use findFirst to get a User object instead of an array of objects.
j
Johnson Detlev
03/03/2022, 7:07 AMSure, but a findFirst adds a LIMIT 1. So that is not the exact translation of the OPs query
m
Motdde
03/04/2022, 6:10 PMI assumed email and username would be unique in a User table.
3 Views