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>})`)

Solution

Mykhailo•3/1/24, 7:32 PM

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

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

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

vr7bdOP•3/1/24, 7:36 PM

Thanks a lot!