searchable_fts
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
2 rows sorted by docid descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Link | rowid | text1 | text2 | content | searchable_fts | docid ▲ | __langid |
---|---|---|---|---|---|---|---|
2 | 2 | terry dog | sara weasel | 2 | 0 | ||
1 | 1 | barry cat | terry dog | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "searchable_fts" USING FTS3 (text1, text2, content="searchable");