DT
Drizzle Team•15mo ago
mmurto

How to filter length in where for postgres?

I have a text field, which I want to select only if it's length is higher than 50. How should I do that? So I basically need to transfer where length(item.content) >= 50 to Drizzle.
2 Replies
Andrii Sherman
Andrii Sherman•15mo ago
.where(sql`length(${item.content}) >= 50`)
.where(sql`length(${item.content}) >= 50`)
Or like this if you need to escape dynamic value 
.where(sql`length(${item.content}) >= ${50}`)
.where(sql`length(${item.content}) >= ${50}`)
content column from item table will be automatically escaped
mmurto
mmurto•15mo ago
Thanks a lot!
Want results from more Discord servers?
Add your server
More Posts
Is there currently a way to utilize onUpdate?Trying to run `ON UPDATE NOW()` for a `last_updated` column for whenever the row is changed.Migrations not working on github actionsAny suggestions to debug this on actions? Is it possible that the database is not created?"The supplied SQL string contains more than one statement" after running "generate:sqlite"I just updated one of my schemas with a few columns and now my project is broken. This is the gener[bug] Some sql statement looks broken when bulk insert```ts await db.insert(users) .values( { name: 'Andrew', createdAt: new Date(), Return first or throwI have a hard time believing this hasn't been asked yet, but my search results have yet to yield anyCan't find meta/_journal.json file when running migrateTrying to run `migrate()` from a lambda function and I can't figure out why it's unable to find the Wrong type on decimalsHello, I have encountered something interesting. The first screenshot shows what I'm inserting into CheckHello there, from this discussion: https://discord.com/channels/1043890932593987624/1090486363251544