<[EMAIL PROTECTED]> wrote: > I thought I can create two separate indexes: on name and on email, > and when I execute a query with "name LIKE 'value' OR email > LIKE 'value'" both indexes would be used. >
If you are building an email indexing system, you problem want to use Full Text Search with fts3, not the LIKE operator. See http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------