Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Case-insensitive SQL LIKE pattern matching.
Syntax
ilike(other)
Parameters
| Parameter | Type | Description |
|---|---|---|
other |
str | SQL LIKE pattern string |
Returns
Column (boolean)
Examples
df = spark.createDataFrame(
[(2, "Alice"), (5, "Bob")], ["age", "name"])
df.filter(df.name.ilike('%Ice')).collect()
# [Row(age=2, name='Alice')]