← Back to Stormify Documentation

stormify/onl.ycode.stormify/SqlDialect/caseInsensitiveLike

caseInsensitiveLike

fun caseInsensitiveLike(column: String): Pair<String, String>

Returns the column expression and LIKE operator for case-insensitive matching.

PostgreSQL: uses ILIKE natively
MySQL, MariaDB, SQLite, SQL Server: LIKE is already case-insensitive
Oracle, H2, HSQLDB, Derby: wraps column in LOWER()

Return

Pair of (column expression, LIKE operator)