Match a string

Only relevant for text and tsvector columns. Match only rows where column matches the query string in query.

For more information, see Postgres full text search.

Parameters

column

REQUIRED

string

The text or tsvector column to filter on

query

REQUIRED

string

The query text to match with

options

Optional

object

Named parameters

config

Optional

string

The text search configuration to use

type

Optional

"plain" | "phrase" | "websearch"

Change how the `query` text is interpreted


const { data, error } = await supabase
  .from('quotes')
  .select('catchphrase')
  .textSearch('catchphrase', `'fat' & 'cat'`, {
    config: 'english'
  })