Read data from FTS table?

Question

In one of implementing feature set application have to perform frequent Search Query directly from sqlite data Base. I found FTS could be better way to perform faster search. I created it but it's returning no data. I checked by opening db file, Virtual Table Created but no data there.

My question is, does Virtual Table required to insert data manually before to fetch any data. Any suggestion !!

Answer 1

The documentation says:

FTS tables are populated using INSERT, UPDATE and DELETE statements in the same way as ordinary SQLite tables are.