On Sat, Nov 29, 2008 at 7:56 PM, Rael Bauer <[EMAIL PROTECTED]> wrote: > Previously someone advised that I use the "*" char to achieve partial search > results with fts. eg ver* will match version. This works ok, but only for > end parts of a word. > > Is there anyway to get partial matches for beginning or middle parts of a > word? > > e.g. *sion - to match version or > *si* to match version
Unfortunately, no. Prefix searches are possible because the fts index is stored in sorted order. Doing something like *ed would involve a full scan of the index, and would probably be very slow. -scott _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
