On Fri, Jun 05, 2009 at 10:53:58AM -0400, German Escallon scratched on the wall:
> Say I have the following record in my DB:
>
> Path: /home/media/mymusic
> filename: rock_my_world
> extension: mp3
>
> I want to be able to find this file by typing any of the following in
> the user interface tha
Hi,
Not sure if that answers your question, but I think you seriously want
to use FTS3. It will be both a trillion times faster than your current
query - you may have trouble with your last example though. Maybe you
can still go through by escaping the search terms.
http://www.sqlite.org/cvstrac/
2 matches
Mail list logo
