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