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: /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 that I'll provide. ?> rock ?> rock_my_world ?> mp3 ?> mymusic ?> rock_my_world.mp3 ?> /home/media/mymusic/rock_my_world.mp3 I am doing something along the lines of: SELECT basename, extension FROM tb_file WHERE (basename LIKE "%<searchTerm>%") OR (extension LIKE "%<searchTerm>%") OR (path LIKE "%<searchTerm>%"); The above returns the right results for the first 4 cases, but not the last two. Any suggestions?? Thank you in advance. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
