From 0be039b475ce9160b91eb82e52ca972b3785121c Mon Sep 17 00:00:00 2001
From: Adrien Saurat <adrien.saurat@biblibre.com>
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