searchable_fts

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ text1 text2 name with . and spaces content 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

CSV options: 

CREATE VIRTUAL TABLE "searchable_fts"
    USING FTS3 (text1, text2, [name with . and spaces], content="searchable");