Python: Column matches a case-insensitive pattern

Match only rows where column matches pattern case-insensitively.

Parameters

• column

  (Required)

  The name of the column to apply a filter on

• pattern

  (Required)

  The pattern to match by

Examples

With `select()`

response = (
    supabase.table("planets")
    .select("*")
    .ilike("name", "%ea%")
    .execute()
)