From 0be039b475ce9160b91eb82e52ca972b3785121c Mon Sep 17 00:00:00 2001 From: Adrien Saurat Date: Fri, 25 Nov 2011 14:52:53 +0100 Subject: [PATCH] Bug 7053: patron name search Allows search on names containing spaces. Example: "LA JOIE" Allows search on strings included in name Example: "james acevedo" to find "henry hames acevedo III" --- C4/SQLHelper.pm | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/SQLHelper.pm b/C4/SQLHelper.pm index e1cb5d0..982f18b 100644 --- a/C4/SQLHelper.pm +++ b/C4/SQLHelper.pm @@ -487,8 +487,8 @@ sub _Process_Operands{ } if ($searchtype eq "start_with"){ foreach (@$operand) { - push @tmpkeys,("$field LIKE ?","$field LIKE ?"); - push @localvaluesextended, ("$_\%", " $_\%") ; + push @tmpkeys,("$field LIKE ?","$field LIKE ?"); + push @localvaluesextended, ("$operand\%", "\% $operand\%") ; } } push @values,@localvaluesextended; -- 1.7.2.5