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

python - How to insert QWidgets in the middle of a Layout? -

python - serve multiple gunicorn django instances under nginx ubuntu -

module - Prestashop displayPaymentReturn hook url -