Hey. I'm trying to do `query.orderBy(column)` This...
# exposed
a
Hey. I'm trying to do
query.orderBy(column)
This column is a string column, and I want the
orderBy
statement NOT to be case sensitive. How can I achieve that? (without changing the column altogether to
.lowercase()
b
https://stackoverflow.com/questions/2413427/how-to-use-sql-order-by-statement-to-sort-results-case-insensitive/2413833 alas, that's just the way it is. I did not find a ready-made collate operator, but you can write it
Copy code
MyTable.selectAll()
   .orderBy(MyTable.name.lowerCase())
🙌 1
a
You're correct. That's the way to do it! Thank you 😄