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
stringThe text or tsvector column to filter on
query
REQUIRED
stringThe query text to match with
options
Optional
objectNamed parameters
config
Optional
stringThe text search configuration to use
type
Optional
"plain" | "phrase" | "websearch"Change how the `query` text is interpreted
const result = await supabase
.from("texts")
.select("content")
.textSearch("content", `'eggs' & 'ham'`, {
config: "english",
});