D1_ERROR: near \"ilike\":
Can anyone spot what I'm doing wrong?
Drizzle:
Logs this output:
I get this error:
Drizzle:
export async function searchByFontFamilyName(db: DB, search: string) {
return db
.select({
family: table_fonts.family,
})
.from(table_fonts)
.where(
ilike(table_fonts.family, `%${search}%`), // search: "nato"
);
}export async function searchByFontFamilyName(db: DB, search: string) {
return db
.select({
family: table_fonts.family,
})
.from(table_fonts)
.where(
ilike(table_fonts.family, `%${search}%`), // search: "nato"
);
}Logs this output:
Query: select "family" from "fonts" where "fonts"."family" ilike ? -- params: ["%nato%"]Query: select "family" from "fonts" where "fonts"."family" ilike ? -- params: ["%nato%"]I get this error:
D1_ERROR: near \"ilike\": syntax error at offset 66D1_ERROR: near \"ilike\": syntax error at offset 66The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Similar Threads
Was this page helpful?
