Hi, I'm finding my way through FTS3/FTS4 to replace some of the old code
that we have for searching terms within titles. I now know that FTS3/4
should be the way to proceed.
So far, I have this:
- an FTS4 table that has two columns: title (main column), ext (certain
conditions to match)
- an FTS4aux table
What I'd like to be able to do is something like this:
- let's say that the FTS4 table has values such as:
* mohit sindhwani, onghu
* john doe, gmail
* james ling, alibaba
* john barn, yahoo
...and so on
If the user enters "j", I'd like to suggest that this would complete to
the words:
john and james in the current set
If the user enters 'ling j', I'd like to restrict it and say:
> james is the only word that can be matched now
> james ling, alibaba is the result
Similarly, if the user enters 'yahoo j', I should be able to zoom in to
'john barn, yahoo'.
I think this should be within the reach of FTS3/FTS4, but I'm having
trouble framing the queries, etc. Are you able to nudge me in the
correct direction?
Thanks,
Mohit.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
