Which version of SQLite are you using? If LIKE has been overridden in the implementation you're using, it won't have the advantage of an index whatever the collation, in which case you might consider GLOB though it is case-sensitive. Regards Tim Romano _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] Optimising usage of LIKE Ian Hardingham
- Re: [sqlite] Optimising usage of LIKE Simon Slavin
- Re: [sqlite] Optimising usage of LIKE Black, Michael (IS)
- Re: [sqlite] Optimising usage of LIKE Black, Michael (IS)
- Re: [sqlite] Optimising usage of LIKE Tim Romano
- Re: [sqlite] Optimising usage of LIKE Tim Romano
- [sqlite] Optimising usage of LIKE Ian Hardingham