[Koha-bugs] [Bug 4340] New: patron name search does not handle punctuated names

[bugzilla-daemon at kohaorg.ec2.liblime.com]

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4340

           Summary: patron name search does not handle punctuated names
           Product: Koha
           Version: HEAD
          Platform: All
        OS/Version: All
            Status: ASSIGNED
          Severity: enhancement
          Priority: P5
         Component: Circulation
        AssignedTo: dbavousett at ptfs.com
        ReportedBy: dbavousett at ptfs.com
   Estimated Hours: 0.0
 Change sponsored?: ---


In C4::Members::SearchMember, the system is searching for surnames like
"string%" or "% string%".  Thus, for a search "steuben", you'll get Steuben,
Steubenstein, or Von Steuben, but not "D'Steuben" or "Smith-Steuben".

One of our customers would like this to work to find these punctuated names
correctly, but merely using LIKE "%string%" is not the answer; in a search for
"van", you want to find "Smith-Vandenberg" "Van Smith" or "Vanilla", but not
"Sullivan".  

mysql has the capability of doing REGEXP there, but it is very, very slow, but
I found a resource describing a method of using a more-general LIKE, then
REGEXPing that, which testing indicates is *much* faster than adding a bunch of
LIKEs for all the combinations.

Patch coming shortly.


-- 
Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.