Column matches a case-insensitive pattern

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