searchable_fts

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

2 rows

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

Link rowid ▼ text1 text2 content searchable_fts docid __langid
1 1 barry cat terry dog     1 0
2 2 terry dog sara weasel     2 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE "searchable_fts"
    USING FTS3 (text1, text2, content="searchable");