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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
