Spoken like a true computer geek ... I'm sorry, but just because it's hard on the computer doesn't mean that someone isn't going to want to do it. Admittedly, our db isn't that big, but "partial" means partial, it does not mean "starts with". Two suggestions - either add it as an option, warning that it will need to scan the entire index and hence is likely to be slow, or create an index that progressively strips leading characters. To speed a brute force search up, you could possibly create a file that consists solely of the words, so you can search that file for matches, and then look up the match in the index itself. Actually - a third option too - create a "flipped word" index so you can do an "ends with" search. Cheers, Wol -----Original Message----- From: bugzilla-daemon@wilbur.katipo.co.nz [mailto:bugzilla-daemon@wilbur.katipo.co.nz] Sent: 24 April 2003 15:47 To: koha-devel@lists.sourceforge.net Subject: [Koha-devel] [Bug 363] Searching on contains works only with full names. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=363 paul.poulain@free.fr changed: What |Removed |Added ------------------------------------------------------------------------ ---- Status|NEW |RESOLVED Resolution| |REMIND ------- Additional Comments From paul.poulain@free.fr 2003-04-25 02:46 ------- it's not a bug, it's a feature. I can easily add a search on the beginning of the word. It's a very bad idea to add a like %word%, performance would be really poor... so, do we keep "full word only" search or do "starting word" ? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel