3 replies

case insensitive orderBy

I want to do an

orderBy

orderBy

that is case insensitive. How do I do it?

Solution

Hello, @vr7bd. I think you can try smth like this:

 .orderBy(sql`lower(${<YOUR_COLUMN>})`)

 .orderBy(sql`lower(${<YOUR_COLUMN>})`)

case insensitive orderBy - Drizzle Team