Index: branches/dev/data/class/SC_CustomerList.php
===================================================================
--- branches/dev/data/class/SC_CustomerList.php	(revision 12429)
+++ branches/dev/data/class/SC_CustomerList.php	(revision 12431)
@@ -207,5 +207,5 @@
             	$this->setWhere( "email LIKE '%@docomo.ne.jp%' OR email LIKE '%@softbank.ne.jp%' OR email LIKE '%@ezweb.ne.jp%' OR email LIKE '%vodafone.ne.jp'" );
         	}elseif($this->arrSql['mail_type']==2){
-        		$this->setWhere( "email_mobile LIKE '%@docomo.ne.jp%' OR email_mobile LIKE '%@softbank.ne.jp%' OR email_mobile LIKE '%@ezweb.ne.jp%' OR email_mobile LIKE '%@vodafone.ne.jp%'" );
+        		$this->setWhere( "email_mobile LIKE '%@docomo.ne.jp%' OR email_mobile LIKE '%@softbank.ne.jp%' OR email_mobile LIKE '%@ezweb.ne.jp%' OR email_mobile LIKE '%@vodafone.ne.jp'" );
         	    }
         	}
Index: branches/dev/data/class/SC_SelectSql.php
===================================================================
--- branches/dev/data/class/SC_SelectSql.php	(revision 12315)
+++ branches/dev/data/class/SC_SelectSql.php	(revision 12431)
@@ -45,4 +45,10 @@
 		$return = sfManualEscape($val);
 		$return = "%" .$return. "%";
+		return $return;
+	}
+	
+	function addSearchEnd($val) {
+		$return = sfManuaiEscape($val);
+		$return = "%" .$return;
 		return $return;
 	}