<PSQL Case insensitive search using Exposed> How c...

# stackoverflow

[user]

PSQL Case insensitive search using Exposed
How can we do case insensitive search using Exposed(Kotlin) on a postgres sql database?

SELECT users.id, users.name, users.created_at, users.updated_at FROM users
WHERE users.name iLIKE '%aaa%'


There is like operator. I don't see ilike operator. Should I be using lowercase on the query field?