searchable_fts

2 rows

✎ View and edit SQL

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

Link rowid ▼ text1 text2 name with . and spaces searchable_fts rank
1 1 barry cat terry dog panther 14  
2 2 terry dog sara weasel puma 14  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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