Module org.jooq
Package org.jooq.impl

Interface QOM.ContainsIgnoreCase<T>

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

public static interface QOM.ContainsIgnoreCase<T> extends QOM.CompareCondition<T,QOM.ContainsIgnoreCase<T>>
The CONTAINS IGNORE CASE operator.

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

This translates to this ilike ('%' || escape(value, '\') || '%') escape '\' in SQLDialect.POSTGRES, or to lower(this) like lower(('%' || escape(value, '\') || '%') escape '\') in all other dialects.