sqlite fts4 or fts5
Posted: Mon Nov 28, 2016 12:13 pm
hi,
does anyone have experience with the use of sqlite's fts4 or fts5 full text search or maybe even have a working example?
the should be something possibele such as
but the select does not bring any result (the virual tabe is filled with data).
thanks
does anyone have experience with the use of sqlite's fts4 or fts5 full text search or maybe even have a working example?
the should be something possibele such as
Code: Select all
Begin Transaction;
Create Virtual Table booksearch Using fts4(content='books', ISBN,ISBN10,doi,dewey,title,subtitle,comments,contents,synopsis,Authors);
Commit Transaction;
Select * From booksearch where booksearch match '0124171591';
thanks