Match a string

Finds all rows whose tsvector value on the stated column matches to_tsquery(query).

column

REQUIRED

String

The text or tsvector column to filter on.

query

REQUIRED

String

The query text to match with.

config

Optional

String

The text search configuration to use.

type

Optional

TextSearchType

Change how the query text is interpreted.


final data = await supabase
  .from('quotes')
  .select('catchphrase')
  .textSearch('catchphrase', "'fat' & 'cat'",
    config: 'english'
  );