Home

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).

Parameters
  • 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%');