case insensitive orderBy

I want to do an 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>})`)

...

2 Replies

Solution

Mykhailo•12mo ago

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

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

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

vr7bdOP•12mo ago

Thanks a lot!