Код

Код


async function main() {

 const limit = 10;

 const jsonFieldName = "firstName";

 const jsonFieldValue = "John";


 const result = await prisma.$queryRaw<Array<{ name: string }>>(

  Prisma.sql`SELECT DISTINCT

    (name)

  FROM

    Account

  WHERE

    meta ->> "$.${jsonFieldName}" = ${jsonFieldValue}

  LIMIT ${limit};

`

 );

}

Report Page