Mysql compare json arrays

I have a column that is a json of array of strings.

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

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

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

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

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

but its unable to find a object even though I know the exact record is in the DB, how should I approach with querying mysql jsons with drizzle? Should I just use raw sql?

Drizzle Team•2y ago

ocelot2123

Mysql compare json arrays

I have a column that is a json of array of strings.

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

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

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

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

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

but its unable to find a object even though I know the exact record is in the DB, how should I approach with querying mysql jsons with drizzle? Should I just use raw sql?

Mysql compare json arrays

Mysql compare json arrays

Similar Threads