arrayOverlaps case insensitive

is it possible to make arrayOverlaps case insensitive in drizzle ?
const fetchFromDb = async (names : string[]) => {
const result = await db.select().from(manhwa)
.where(
arrayOverlaps(manhwa.synonyms, names)
)
.limit(1)
console.log(result)
return result
}


// const name = "Attack on titan";
const name = "shejio no kyjin";
const synonyms = ["synonym1", "Amine"];

fetchFromDb([name, ...synonyms]);
const fetchFromDb = async (names : string[]) => {
const result = await db.select().from(manhwa)
.where(
arrayOverlaps(manhwa.synonyms, names)
)
.limit(1)
console.log(result)
return result
}


// const name = "Attack on titan";
const name = "shejio no kyjin";
const synonyms = ["synonym1", "Amine"];

fetchFromDb([name, ...synonyms]);
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?