IBM Books
(C) IBM Corp. 2000

Net Search Extender

°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼­

Äõ¸® ÀÛ¼º

ÀÌ ¿¹´Â CONTAINS ÇÔ¼ö°¡ texttab Å×À̺íÀÇ comment Ä÷³¿¡¼­ ÅØ½ºÆ®¸¦ °Ë»öÇÏ´Â ¹æ¹ýÀ» Ç¥½ÃÇÕ´Ï´Ù. ÀÌ ÇÔ¼ö´Â ÅØ½ºÆ®°¡ °Ë»ö Àμö¸¦ ÁöÁ¤ÇÒ °æ¿ì¿¡´Â 1À» ¸®ÅÏÇϰí ÁöÁ¤ÇÏÁö ¾ÊÀ» °æ¿ì¿¡´Â 0À» ¸®ÅÏÇÕ´Ï´Ù.

SELECT AUTHOR,TITLE
    FROM DB2EXT.TEXTTAB
        WHERE CONTAINS(COMMENT, '"book"') = 1
 

ÀÌ ¿¹¿¡¼­´Â COMMENT Ä÷³¿¡¼­ bookÀ̶ó´Â ¿ë¾î¸¦ °Ë»öÇÕ´Ï´Ù.

Âü°í

¼º´ÉÀ» Çâ»ó½ÃŰ·Á¸é, Á¦ÇÑÀûÀÎ °Ë»ö ±âÁØÀ» Ãß°¡ÇÏ´Â °ÍÀÌ ¹Ù¶÷Á÷ÇÕ´Ï´Ù. ¿¹¸¦ µé¸é ´ÙÀ½°ú °°½À´Ï´Ù.

SELECT AUTHOR,TITLE
        FROM db2ext.texttab
        WHERE CONTAINS(COMMENT, '"book"') = 1 AND PRICE < 20
 


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]