Drizzle Mysql compare json arrays

I have a column that is a json of array of fileURLs (string).

I'm trying to query based on array of urls as input like this:

// table schema
fileURLs: json("fileURLs").$type<string[]>().notNull(),

const fileURLs: string[];
await db.query.table.findFirst({
        where: and(
          eq(table.fileURLs, fileURLs),
        )
)

// table schema
fileURLs: json("fileURLs").$type<string[]>().notNull(),

const fileURLs: string[];
await db.query.table.findFirst({
        where: and(
          eq(table.fileURLs, fileURLs),
        )
)

// table schema
fileURLs: json("fileURLs").$type<string[]>().notNull(),

const fileURLs: string[];
await db.query.table.findFirst({
        where: and(
          eq(table.fileURLs, fileURLs),
        )
)

// table schema
fileURLs: json("fileURLs").$type<string[]>().notNull(),

const fileURLs: string[];
await db.query.table.findFirst({
        where: and(
          eq(table.fileURLs, fileURLs),
        )
)

but its unable to find a object, how should I approach with querying mysql jsons with drizzle? Should I just use raw sql?

Neto•4/4/24, 10:39 AM

using equals on postgres works just fine, should be the same for mysql as well

Neto•4/4/24, 10:39 AM

Neto•4/4/24, 10:40 AM

you can use raw drizzle with json operators as well

Neto•4/4/24, 10:41 AM

Drizzle Mysql compare json arrays

Similar Threads

Similar Threads

Similar Threads