¿ù°£ Àα⠰Խù°

°Ô½Ã¹° 58°Ç
   
MYSQL ´ë¼Ò¹®ÀÚ °Ë»ö binary(name)
±Û¾´ÀÌ : ÃÖ°í°ü¸®ÀÚ ³¯Â¥ : 2012-11-09 (±Ý) 15:20 Á¶È¸ : 6883
±ÛÁÖ¼Ò :
                          

mysql> select code, name TX_ORXXX where od_uts like '2012-11-09%' and binary(name) like'CLOUD V%';
+------------------+--------------------+
| product_code     | product_name       |
+------------------+--------------------+
| CLD_V_WIN_SINGLE | CLOUD V WIN SINGLE |
| CLD_V_LNX_SINGLE | CLOUD V LNX SINGLE |
+------------------+--------------------+
2 rows in set (0.00 sec)

mysql>
mysql>
mysql> select code, name from TX_ORXXX where od_uts like '2012-11-09%' and name like'CLOUD V%';
+------------------+---------------------+
| product_code     | product_name        |          
+------------------+---------------------+
| CLD_V_WIN_SINGLE | CLOUD V WIN SINGLE  | 
| CLD_V_LNX_SINGLE | CLOUD V LNX SINGLE  |
| ETC_CLD_IMGPARK  | Cloud V |
+------------------+---------------------+
3 rows in set (0.00 sec)


À̸§ Æнº¿öµå
ºñ¹Ð±Û (üũÇÏ¸é ±Û¾´À̸¸ ³»¿ëÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.)
¿ÞÂÊÀÇ ±ÛÀÚ¸¦ ÀÔ·ÂÇϼ¼¿ä.
   

 



 
»çÀÌÆ®¸í : ¸ðÁö¸®³× | ´ëÇ¥ : ÀÌ°æÇö | °³ÀÎÄ¿¹Â´ÏƼ : ·©Å°´åÄÄ ¿î¿µÃ¼Á¦(OS) | °æ±âµµ ¼º³²½Ã ºÐ´ç±¸ | ÀüÀÚ¿ìÆí : mojily°ñ¹ðÀÌchonnom.com Copyright ¨Ï www.chonnom.com www.kyunghyun.net www.mojily.net. All rights reserved.