Only relevant for text and tsvector columns. Match only rows where column
matches the query string in query
.
The text or tsvector column to filter on
The query text to match with
Named parameters
const result = await supabase
.from("texts")
.select("content")
.textSearch("content", `'eggs' & 'ham'`, \{
config: "english",
\});
const \{ data, error \} = await supabase
.from('quotes')
.select('catchphrase')
.textSearch('catchphrase', `'fat' & 'cat'`, \{
type: 'plain',
config: 'english'
\})
const \{ data, error \} = await supabase
.from('quotes')
.select('catchphrase')
.textSearch('catchphrase', `'fat' & 'cat'`, \{
type: 'phrase',
config: 'english'
\})
const \{ data, error \} = await supabase
.from('quotes')
.select('catchphrase')
.textSearch('catchphrase', `'fat or cat'`, \{
type: 'websearch',
config: 'english'
\})