pyspark.sql.Column.ilike

Column.ilike(other: str) → pyspark.sql.column.Column

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

Parameters
otherstr

a SQL LIKE pattern

Examples

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