Del via


ilike (Column)

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')]