Hi guys, Has a solution already been made for case insensitive findMany querying? For example, here I would like to search in the title field, but contains is case sensitive. I am looking for an option in the API, or something like "containsInsensitive:searchString"

return ctx.prisma.post.findMany({
      where: {
        OR: [
          {
            title: {
              contains: searchString,
            },
          },
          {
            content: {
              contains: searchString,
            },
          },
        ],
      },
    })

Hey @Vince Biro Currently not but you can create a feature request here https://github.com/prisma/prisma/issues/new?assignees=&labels=&template=feature_request.md&title=

this was also a problem in prisma 1. but now at least we have accese to raw sql. so... `searchString = `%${searchString}%`` `const posts = await prisma.raw`SELECT * FROM Post WHERE LOWER(title) LIKE ${search} OR title LOWER(content) ${search};`;`

Thanks for you answer @Joshua Waurich , it helped me a lot! Just a little addition to your solution: I had to wrap the

${search}

variable with quotation marks (

'${search}'

) to make it work.

I also hit this exact problem earlier today

FR created at https://github.com/prisma/prisma/issues/2316