The short answer is no. If you want to use the database for the purposes for which it was created, then you have to play by its rules- which in this case is to create fields for each of those categories.
On Tue, Mar 11, 2008 at 10:38 PM, Derek Developer <[EMAIL PROTECTED]> wrote: > Is it possible to search a sequence of bytes within a BLOB? > Lets say i have a BLOB that contains 4 text fields 32 characters long ie > firstname, lastname, street, city. > > Can I form a query that looks something like: > SELECT Bytes33to64 FROM MyTable WHERE Bytes33to64 LIKE 'Jones' > > instead of > SELECT lastname FROM MyTable WHERE lastname LIKE 'Jones' > > Is there anyway to do this? > > This would allow me to store a single UDT as a BLOB and treat it like a > series of columns in a table. > > > --------------------------------- > Looking for last minute shopping deals? Find them fast with Yahoo! Search. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users