On Oct 9, 2011, at 12:15 PM, Mohit Sindhwani wrote: > create table titles (id integer primary key, title text, ...); > could we sort the records by title and use that in some way to restrict the > search space when searching titles starting with a specific letter?
You might be better off moving your 'title' column to a FTS virtual table. http://www.sqlite.org/fts3.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users