How I can get random data from prisma?
# orm-helpn
Naotho Machida
08/19/2021, 1:44 PMHow I can get random data from prisma?
✅ 1
r
Ryan
08/19/2021, 1:47 PM@Naotho Machida 👋
Not supported directly yet, so you would need to use a raw query.
It would be great if you could add a 👍 on the above request.
n
Naotho Machida
08/19/2021, 1:51 PMHi Ryan! Ok
😉
Naotho Machida
08/19/2021, 1:52 PMHow I can see the actual SQL Request?
o
Oluwasetemi Ojo
08/19/2021, 2:59 PMconst result = await prisma.$queryRaw('SELECT * FROM User;')Oluwasetemi Ojo
08/19/2021, 3:00 PMcheck the docs for more https://www.prisma.io/docs/concepts/components/prisma-client/raw-database-access
n
Naotho Machida
08/19/2021, 5:48 PMVery thanks! Solved
o
Oluwasetemi Ojo
08/19/2021, 7:26 PMCould you share a bit on how you were able to achieve the random fetching.
8 Views