Re: [sqlite] Search in multiple fields.

2009-06-05 Thread Jay A. Kreibich
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

Re: [sqlite] Search in multiple fields.

2009-06-05 Thread Alexandre Courbot
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.

[sqlite] Search in multiple fields.

2009-06-05 Thread German Escallon
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: