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