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

See also

pyspark.sql.Column.rlike

Examples

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

pyspark.sql.Column.getItem pyspark.sql.Column.isNotNull