Index: branches/dev/html/admin/order/index.php
===================================================================
--- branches/dev/html/admin/order/index.php	(revision 17)
+++ branches/dev/html/admin/order/index.php	(revision 225)
@@ -90,10 +90,18 @@
 			switch ($key) {
 				case 'search_order_name':
-					$where .= " AND order_name01||order_name02 ILIKE ?";
+					if(DB_TYPE == "pgsql"){
+						$where .= " AND order_name01||order_name02 ILIKE ?";
+					}elseif(DB_TYPE == "mysql"){
+						$where .= " AND concat(order_name01,order_name02) ILIKE ?";
+					}
 					$nonsp_val = ereg_replace("[ ¡¡]+","",$val);
 					$arrval[] = "%$nonsp_val%";
 					break;
 				case 'search_order_kana':
-					$where .= " AND order_kana01||order_kana02 ILIKE ?";
+					if(DB_TYPE == "pgsql"){
+						$where .= " AND order_kana01||order_kana02 ILIKE ?";
+					}elseif(DB_TYPE == "mysql"){
+						$where .= " AND concat(order_kana01,order_kana02) ILIKE ?";
+					}
 					$nonsp_val = ereg_replace("[ ¡¡]+","",$val);
 					$arrval[] = "%$nonsp_val%";
@@ -126,5 +134,9 @@
 					break;
 				case 'search_order_tel':
-					$where .= " AND (order_tel01||order_tel02||order_tel03) ILIKE ?";
+					if(DB_TYPE == "pgsql"){
+						$where .= " AND (order_tel01||order_tel02||order_tel03) ILIKE ?";
+					}elseif(DB_TYPE == "mysql"){
+						$where .= " AND concat(order_tel01,order_tel02,order_tel03) ILIKE ?";
+					}
 					$nonmark_val = ereg_replace("[()-]+","",$val);
 					$arrval[] = "$nonmark_val%";