searchable_fts
2 rows
This data as json, CSV (advanced)
Link | rowid ▼ | text1 | text2 | name with . and spaces | searchable_fts | docid | __langid |
---|---|---|---|---|---|---|---|
1 | 1 | barry cat | terry dog | panther | 1 | 0 | |
2 | 2 | terry dog | sara weasel | puma | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "searchable_fts" USING FTS4 (text1, text2, [name with . and spaces], content="searchable");