Column matches a case-insensitive pattern
Match only rows where column
matches pattern
case-insensitively.
Parameters
- columnREQUIREDstring
The column to filter on
- patternREQUIREDstring
The pattern to match with
const { data, error } = await supabase
.from('countries')
.select()
.ilike('name', '%alba%')