A little bit different. That sentence of "full text search" is split as [ful, tex, sea, ull, ll, l, ext, xt, xt, ear, arc, rch, ch, h] with 3 maximum length of key. Of course, search pattern string length is limited to 3 and query is changed as follows.
[Example: search 'earch'] SELECT ... FROM [FTS table] WHERE [search fields or table] MATCH 'ear' AND ([search field1] like '%earch%' OR [search field2] like '%earch%' OR ... OR [search fieldn] like '%earch%') The reason of ... 1) 3 characters: To minimize FTS index size and to improve search performance 2) Adding like clauses: To refine result set 2) many likes: To search all columns in FTS table when a table name is used in MATCH clause. BR, Yongil Jang. 2012/11/9 Paul Vercellotti <pverce...@yahoo.com> > > > That's a promising project; I hope it reaches maturity. > > I assume your modified tokenizer did a similar thing, like tokenizing > "full text search" as [full, text, search, ull, ll, l, ext, xt, xt, earch, > arch, rch, ch, h]? > > What worked and what did not work? > > Thanks, > Paul > > > ________________________________ > From: Yongil Jang <yongilj...@gmail.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Sent: Thursday, November 8, 2012 2:26 PM > Subject: Re: [sqlite] FTS substring behavior > > How about look at following URL? > > https://github.com/jonasfj/trilite > > AFAIK, FTS doesn't support substring search. > I also tried to edit FTS to find substring by changing simple tokenizer. > It was worked partially, but not a good solution to use generally. > > > 2012/11/9 Dan Kennedy <danielk1...@gmail.com> > > > On 11/09/2012 01:49 AM, Paul Vercellotti wrote: > > > >> > >> > >> Hi there, > >> > >> I wanted to clarify if FTS could provide any optimization for substring > >> matches like '*ion*' or similar? > >> > > > > No. I think it will actually search for tokens that start with the 4 > > ASCII characters "*ion" if you try that. > > > > Dan. > > > > ______________________________**_________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users< > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
