fts (Full Text Search) - AFS

AFS Integration Guide

Reference Guide

A full-text search predicate filters the documents containing keywords. Building a full-text search predicate involves calling the built-in function fts that takes one string argument, representing the keywords of the query.

The keywords are standardized by AFS before their evaluation — this standardization replaces each keyword by its lowercase, without accents, value.

For example, fts("query") or fts("Query") return the same results, which stand for all documents containing "query" or "Query" or "QUERY", or else.

Usage example


It is possible to use a wildcard within fts predicate. A wildcard is a character that may be used in a search term to represent one or more other characters.

See Wildcard Search for more information.