users_fts
2 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | login | name | users_fts | rank |
---|---|---|---|---|---|
53015001 | 53015001 | dogsheep | dogsheep | 135 | |
9599 | 9599 | simonw | simonw | 135 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [users_fts] USING FTS5 ( [login], [name], content=[users] );