```const data = await prisma.$queryRaw`SELECT * FR...
# orm-help
c
Copy code
const data = await prisma.$queryRaw`SELECT * FROM Series WHERE name LIKE '%${series}%';`
Copy code
prisma:info Starting a sqlite pool with 17 connections.
prisma:query SELECT * FROM Series WHERE name LIKE '%?%';
/Users/chriscoughlan/Code/longbox/backend/node_modules/@prisma/client/runtime/index.js:38703
          throw new PrismaClientKnownRequestError(message, e.code, this.prisma._clientVersion, e.meta);
                ^
PrismaClientKnownRequestError: 
Invalid `prisma.queryRaw()` invocation:


  Raw query failed. Code: `N/A`. Message: `N/A`
    at cb (/Users/chriscoughlan/Code/longbox/backend/node_modules/@prisma/client/runtime/index.js:38703:17)
    at async Proxy._request (/Users/chriscoughlan/Code/longbox/backend/node_modules/@prisma/client/runtime/index.js:40853:18) {
  code: 'P2010',
  clientVersion: '3.9.1',
  meta: { code: 'N/A', message: 'N/A' }
}
Any ideas?
t
The % in the like needs to be inside the variable, ex. `const data = await prisma.$queryRaw`SELECT * FROM Series WHERE name LIKE ${'%'+series+'%'};`
👍 1