"Tima Fourie" <[email protected]> wrote in message news:363e35f87b5c4cbbb2e34692737dd...@c1 > 1. Let's say I have a field called Field1 in table Table1 with the > following rows: > > "A B C" > "D E F" > "G H I" > > Is there some way I can create an index on just a substring for a > column.
You could install a custom collation (http://sqlite.org/c3ref/create_collation.html) that would only look at and compare substrings, then create an index using that collation. However, it might be a better idea to normalize your schema, by storing these values in three separate columns. > 2. Is there some hidden way we can limit what goes into an index in > the first place and then do a select that would return only those > entries. No. I suppose you could create a table that contains a subset of rowids in another table, then join with it to restrict your searches (though it's not quite clear why you would want to do that). Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
