Andrea Connell wrote: > I was originally using LIKE but since that can't make use of indexing I > found this as an alternative to attempt to speed up the query. > > So if I wanted to search PHONETIC_KEY LIKE 'ABCD%' I replace it with > PHONETIC_KEY >= 'ABCD' AND PHONETIC_KEY < 'ABCE' >
The optimizer in SQLite will use an index for a like clause like your example. See section 4 of http://www.sqlite.org/optoverview.html for details. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users