ilike (Column)

Case-insensitive SQL LIKE pattern matching.

Syntax

Python

ilike(other)

Parameters

Parameter	Type	Description
other	str	SQL LIKE pattern string

Parameter	Type	Description
other	str	SQL LIKE pattern string

Returns

Column (boolean)

Examples

Python

df = spark.createDataFrame(
     [(2, "Alice"), (5, "Bob")], ["age", "name"])
df.filter(df.name.ilike('%Ice')).collect()

Output

# [Row(age=2, name='Alice')]