Flutter: Match a string

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

Parameters

• column

  (Required)

  The text or tsvector column to filter on.

• query

  (Required)

  The query text to match with.

• config

  (Optional)

  The text search configuration to use.

• type

  (Optional)

  Change how the `query` text is interpreted.

Examples

Text search

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

Basic normalization

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

Full normalization

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

Websearch

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