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 that I'll provide.
> ?> rock
> ?> rock_my_world
> ?> mp3
> ?> mymusic
> ?> rock_my_world.mp3
> ?> /home/media/mymusic/rock_my_world.mp3
> The above returns the right results for the first 4 cases, but not the
> last two. Any suggestions?? Thank you in advance.
Build the full path and search against that:
....WHERE (path||filename||'.'||extension LIKE '%<searchTerm>%');
In fact, that's the only WHERE clause you'd need.
BTW, string constants in SQL are single quotes ('), not double (").
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Our opponent is an alien starship packed with atomic bombs. We have
a protractor." "I'll go home and see if I can scrounge up a ruler
and a piece of string." --from Anathem by Neal Stephenson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
