Re: [sqlite] Using WHERE within a BLOB

2008-03-11 Thread Ben Harper
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

[sqlite] Using WHERE within a BLOB

2008-03-11 Thread Derek Developer
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 l