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
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.
Hello all,
I have a table with file information (path, filename, extension, size,
etc), and I would like to enable search on this table based on different
fields with a single input, and/or concatenation of the same. For example..
Say I have the following record in my DB:
Path:
3 matches
Mail list logo