On Fri, Sep 10, 2010 at 05:48:48AM -0500, Peter da Silva wrote: >When I was working on Speedtables query optimizer I added indexed search for >anchored string matches because they are a dead easy case. It's likely SQLite >does this automatically.
SQLite does not automatically add a field to a table containing a mangled substring of another field, whatever strange options you give it. (Oh, and they've apparently never heard of normal forms; site names are stored in two separate places...) R