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

Popular posts from this blog

qt - QML MouseArea onWheel event not working properly when inside QML Scrollview -

java - is not an enclosing class / new Intent Cannot Resolve Constructor -

python - Error importing VideoFileClip from moviepy : AttributeError: 'PermissionError' object has no attribute 'message' -