Index: branches/5.0.x/core/units/helpers/search_helper.php
===================================================================
diff -u -r12892 -r12896
--- branches/5.0.x/core/units/helpers/search_helper.php	(.../search_helper.php)	(revision 12892)
+++ branches/5.0.x/core/units/helpers/search_helper.php	(.../search_helper.php)	(revision 12896)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: search_helper.php 12892 2009-11-10 11:16:33Z alex $
+* @version	$Id: search_helper.php 12896 2009-11-10 17:40:29Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -58,9 +58,20 @@
 			return $ret;
 		}
 
+		/**
+		 * Replace wildcards to match MySQL
+		 *
+		 * @param string $keyword
+		 * @return string
+		 */
+		function transformWildcards($keyword)
+		{
+			return str_replace(Array ('%', '_', '*', '?') , Array ('\%', '\_', '%', '_'), $keyword);
+		}
+
 		function buildWhereClause($keyword, $fields)
 		{
-			$keywords = $this->splitKeyword($keyword);
+			$keywords = $this->splitKeyword( $this->transformWildcards($keyword) );
 
 			$normal_conditions = Array();
 			$plus_conditions = Array();
@@ -175,7 +186,6 @@
 			// process search keyword
 			$search_keyword = $this->Application->GetVar( $event->getPrefixSpecial(true).'_search_keyword');
 			$this->Application->StoreVar( $event->getPrefixSpecial().'_search_keyword', $search_keyword);
-			$search_keyword = str_replace('*', '%', $search_keyword);
 
 			$custom_filter = $this->processCustomFilters($event);
 
@@ -253,6 +263,7 @@
 							$match_to = mb_strtolower($use_phrases ? $this->Application->Phrase($val) : $val);
 
 							foreach ($search_keywords as $keyword => $sign) {
+								// doesn't support wildcards
 								if (strpos($match_to, mb_strtolower($keyword)) === false) {
 									if ($sign == '+') {
 										$filter_value = $table_name.'`'.$field_name.'` = NULL';