Javascript Reference v1.0

Column matches a pattern

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

Parameters
    column
    REQUIRED
    object

    The column to filter on.

    pattern
    REQUIRED
    string

    The pattern to filter with.


const { data, error } = await supabase
  .from('cities')
  .select('name, country_id')
  .like('name', '%la%')