searchable_fts

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

2 rows

View and edit SQL

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

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");
Powered by Datasette · Query took 12.353ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette