pyspark.sql.Column.ilike

Column.ilike(other: Union[Column, LiteralType, DecimalLiteral, DateTimeLiteral]) → Column

SQL ILIKE expression (case insensitive LIKE). Returns a boolean Column based on a case insensitive match.

New in version 3.3.0.

Parameters
otherstr

a SQL LIKE pattern

Examples

>>> df.filter(df.name.ilike('%Ice')).collect()
[Row(age=2, name='Alice')]