Full-text search
Prisma Client supports full-text search for MySQL and for PostgreSQL with the fullTextSearchPostgres preview feature.
Add the preview flag to your generator and re-generate Prisma Client:
generator client {
provider = "prisma-client"
output = "./generated"
previewFeatures = ["fullTextSearchPostgres"]
}bunx prisma generatepnpm prisma generateyarn prisma generatenpx prisma generateconst posts = await prisma.post.findMany({
where: {
body: {
search: "cat | dog",
},
},
});Prisma Client also supports relevance-based ordering on supported databases:
const posts = await prisma.post.findMany({
orderBy: {
_relevance: {
fields: ["title"],
search: "database",
sort: "desc",
},
},
});