On Mon, Nov 21, 2011 at 12:17 AM, Mohit Sindhwani <m...@onghu.com> wrote: > 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.
I think you might want to look at Token Prefix queries: http://sqlite.org/fts3.html#section_3 -- Abhinav _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users