Index: /temp/trunk/html/test/kakinaka/mysql.php
===================================================================
--- /temp/trunk/html/test/kakinaka/mysql.php	(revision 4761)
+++ /temp/trunk/html/test/kakinaka/mysql.php	(revision 4762)
@@ -52,6 +52,11 @@
         dtb_products AS T1 RIGHT JOIN (SELECT product_id AS product_id_sub, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max FROM dtb_products_class GROUP BY product_id) AS T2 ON T1.product_id = T2.product_id_sub
     ) vw_products_allclass ';
-	
-print(preg_replace("/[\r\n\t]/"," ",$sql));
+
+//print(preg_replace("/[\r\n\t]/"," ",$sql));
+
+$sql= "SELECT * fROm ILike = ad fd";
+
+print(eregi_replace("(ILIKE )", "LIKE BINARY ", $sql));
+
 
 print("end");
Index: /temp/trunk/data/lib/slib.php
===================================================================
--- /temp/trunk/data/lib/slib.php	(revision 4761)
+++ /temp/trunk/data/lib/slib.php	(revision 4762)
@@ -2351,4 +2351,15 @@
 }
 
+// ÇÛÎó¤ÎÃæ¤Ë¥Ç¡¼¥¿¤¬Â¸ºß¤·¤Æ¤¤¤ë¤«¥Á¥§¥Ã¥¯¤ò¹Ô¤¦(Âçʸ»ú¾®Ê¸»ú¤Î¶èÊ̤ʤ·)
+function sfInArray($sch, $arr){
+	foreach($arr as $key => $val){
+		if (strcasecmp($sch,$val) == 0){
+			return true;
+		}
+	}
+	
+	return false;
+}
+
 // viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
 function sfChangeView($sql){
@@ -2362,7 +2373,10 @@
 // ILIKE¸¡º÷¤òLIKE¸¡º÷¤ËÊÑ´¹¤¹¤ë
 function sfChangeILIKE($sql){
-	$arrChange = array("ILIKE" => "LIKE BINARY ");
+	$arrChange = array("ILIKE " => "LIKE BINARY ");
+	
+	$changesql = eregi_replace("(ILIKE )", "LIKE BINARY ", $sql);
 	$changesql = strtr($sql,$arrChange);
 	return $changesql;
+	
 }