How to filter json column

how to use drizzle orm to query this ?

example my schema
trxTable
id: int
trxInfo: json (inside this contain name field)

select * from trxTable where irxInfo -> name like 'a%'

Drizzle Team Join

The 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?

Twitter GitHub Discord

Communities Docs About Terms Privacy

Star

Setup for Free

Drizzle Team•2y ago

SNilli

How to filter json column

how to use drizzle orm to query this ?

example my schema
trxTable
id: int
trxInfo: json (inside this contain name field)

select * from trxTable where irxInfo -> name like 'a%'