sqlite fts4 or fts5

[seeker]

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

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';

but the select does not bring any result (the virual tabe is filled with data).

thanks

[seeker]

hi,

i solved the problem. i did not insert the data correctly into the search table.

thanks