sql - Sqlite full text search keyword 'Match' not returning any result -
i working on full text search
on sqlite
using fts4
.
in db have normal table notes
, contains 33 records
.
i created virtual table using fts4
this
create virtual table t3 using fts4(content="notes", user_notes);
i querying this
select user_notes t3 user_notes match 'important'
and this
select user_notes t3 t3 match 'important'
but non of query working, why? getting empty result no error.
the documentation says:
the fts4 module never writes content table, , writing content table not affect full-text index. responsibility of user ensure content table , full-text index consistent.
so when insert notes
table, must insert t3
table. (if actual table filled, use rebuild
fts command.)
Comments
Post a Comment