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
Examples
>>> df.filter(df.name.ilike('%Ice')).collect() [Row(age=2, name='Alice')]