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
- columnREQUIREDstring
The text or tsvector column to filter on
- queryREQUIREDstring
The query text to match with
- optionsOptionalobject
Named parameters
configOptionalstringThe text search configuration to use
typeOptional"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'
})