Column matches a pattern

Match only rows where column is less than or equal to value.

Finds all rows whose value in the stated column matches the supplied pattern (case sensitive).

column

REQUIRED

string

The column to filter on

value

REQUIRED

any

The value to filter with


final data = await supabase
  .from('cities')
  .select('name, country_id')
  .like('name', '%la%');