Bug 4340 - patron name search does not handle punctuated names
authorJ. David Bavousett <dbavousett@ptfs.com>
Tue, 5 Apr 2011 14:26:41 +0000 (16:26 +0200)
committerChris Cormack <chrisc@catalyst.net.nz>
Fri, 8 Apr 2011 02:11:11 +0000 (14:11 +1200)
commitd29fd92f66bba11ee903aaf38da737e711b9e9b1
tree64efca463eaa6e7b554f4024859411d50fba984c
parentd31c1603cca45c4f4b5b9fa8b2a1785e81f6da05
Bug 4340 - patron name search does not handle punctuated names

This patch will enable C4::Members::SearchMember to handle searching for punctuated
names (e.g. the "Jones" in "Smith-Jones" or the "Angelo" in "D'Angelo")

It is possible to add a bunch of LIKE clauses, but that adds to the search time in
a rather dramatic way.  REGEXP, by itself, is also a performance killer, but I found
a suggestion of using a more-general LIKE ANDed with the specific REGEXP, and this
gives excellent performance over other approaches.

Signed-off-by: Guillaume Hatt <guillaume.hatt@enc.sorbonne.fr>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
C4/Members.pm