sections: configuration:table-configuration-fts
This data as json
| id | page | ref | title | content | breadcrumbs | references |
|---|---|---|---|---|---|---|
| configuration:table-configuration-fts | configuration | table-configuration-fts | These configure full-text search for a table or view. See Configuring full-text search for a table or view for full details. fts_table specifies which FTS table to use for search. fts_pk sets the primary key column if it is something other than rowid . searchmode can be set to "raw" to enable SQLite advanced search operators . [[[cog config_example(cog, textwrap.dedent( """ databases: russian-ads: tables: display_ads: fts_table: ads_fts fts_pk: id searchmode: raw """).strip() ) ]]] [[[end]]] | ["Configuration", null, "Table configuration"] | [{"href": "https://www.sqlite.org/fts5.html#full_text_query_syntax", "label": "SQLite advanced search operators"}] |