From d0809199f7d993b5050a914c83a15381b2de67d9 Mon Sep 17 00:00:00 2001 From: x2000habouzit Date: Tue, 12 Oct 2004 21:14:49 +0000 Subject: [PATCH] mysql is in fact case insensitive ... good to know ;p --- include/search.classes.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/include/search.classes.inc.php b/include/search.classes.inc.php index 8d47352..3d8c497 100644 --- a/include/search.classes.inc.php +++ b/include/search.classes.inc.php @@ -18,7 +18,7 @@ * Foundation, Inc., * * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * *************************************************************************** - $Id: search.classes.inc.php,v 1.14 2004-10-12 16:25:27 x2000habouzit Exp $ + $Id: search.classes.inc.php,v 1.15 2004-10-12 21:14:49 x2000habouzit Exp $ ***************************************************************************/ require_once("xorg.misc.inc.php"); @@ -216,7 +216,7 @@ class StringSField extends SField { //Nouvelle version plus rapide $regexp = str_replace('-',' ',$this->value); $regexp = str_replace('*','%',$regexp); - return $field." LIKE LCASE('$regexp%')"; + return "$field LIKE '$regexp%'"; } /** clause ORDER BY correspondant à ce champ de formulaire */ -- 2.1.4