Hello everyone! I’m currently facing an issue, whe...
# orm-help
t
Hello everyone! I’m currently facing an issue, where I’m trying to filter on a postgres field of type
number
. I basically want to filter from an input field, kind of like a
contains
but for a number.. Is that something we can do by any chance? Thanks in advance 🙂
1
w
If I understood correctly.
Copy code
prisma.table.findMany({
  where: { num: { lte: 100 }, num: { gte: 100 } },
});
kinda of like the
BETWEEN
operator
t
oww ok ok that might work 🙂 thank you !
w
cheers, LMK how it goes
n
That’s a pretty neat trick William 🙌 Thanks for sharing! 😄
prisma cool 1