would that make sense to add ilike : infix fun<...

# exposed

[bjonnh]

would that make sense to add ilike : infix fun<T:String?> ExpressionWithColumnType<T>.ilike(pattern: String): Op<Boolean> = ILikeOp(this, QueryParameter(pattern, columnType))

class ILikeOp(expr1: Expression<*>, expr2: Expression<*>) : ComparisonOp(expr1, expr2, "ILIKE")

[tapac]

Is this applicable only for PostgreSQL or any other databases?

[bjonnh]

It looks like by default MySQL is case insensitive for LIKE…

[tapac]

It depends on column collations and yes, default is utf8_general_ci which is case insensitive