On 12/16/2015 03:17 PM, Deon Brewis wrote: > Is it possible to have an index on a computer value? > > > E.g. I have a 40 byte value in one of my columns. I only want an index over > the first 4 bytes of it. > > > However, I don't really want to repeat those 4 bytes inside another column on > the main table. > > > Is there any way to accomplish that?
Something like CREATE TABLE t1(x BLOB); CREATE INDEX i1 ON t1( substr(x, 1, 4) ); https://www.sqlite.org/expridx.html Dan.