Module org.jooq
Package org.jooq.impl

Interface QOM.StartsWithIgnoreCase<T>

All Superinterfaces:
Condition, Field<Boolean>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, Named, OrderField<Boolean>, QOM.CompareCondition<T,QOM.StartsWithIgnoreCase<T>>, QueryPart, SelectField<Boolean>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<Boolean>
Enclosing class:
QOM

public static interface QOM.StartsWithIgnoreCase<T> extends QOM.CompareCondition<T,QOM.StartsWithIgnoreCase<T>>
The STARTS WITH IGNORE CASE operator.

Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

SQL: lower(this) like (lower(escape(value, '\')) || '%') escape '\'

Note: This also works with numbers, for instance val(1133).startsWithIgnoreCase(11)