Jason Boehle wrote: > Is the an FTS syntax that allows me to find a field (or fields) that > start with one of the terms in the search query? > > Or should I just be doing a LIKE query against the FTS table?
Do you want any word starts with? fts_table MATCH 'st*' will match all words like 'st...' I you want a document that starts with? then use fts_column like 'st%' -Steve _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users