°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
¸¶½ºÅ· ¹®ÀÚ´Â ¡º¿ÍÀϵå Ä«µå¡» ¹®ÀÚ¶ó°íµµ Çϸç Á» ´õ À¯¿¬¼ºÀÖ°Ô °Ë»öÀ» ¼öÇàÇÒ ¼ö ÀÖ´Â ¹æ¹ýÀ» Á¦°øÇÕ´Ï´Ù. ¸¶½ºÅ· ¹®ÀÚ´Â °Ë»öÀ¸·Î ã´Â ÅØ½ºÆ® ¹®¼ÀÇ ¼ö¸¦ Áõ°¡½Ãŵ´Ï´Ù.
DB2 Net Search Extender´Â ÆÛ¼¾Æ®(%)¿Í ¹ØÁÙ(_)ÀÇ µÎ °¡Áö ¸¶½ºÅ· ¹®ÀÚ¸¦ »ç¿ëÇÕ´Ï´Ù.
SELECT AUTHOR,TITLE FROM DB2EXT.TEXTTAB WHERE CONTAINS(COMMENT, '"thr%er"') = 1
ÀÌ °Ë»ö ¿ë¾î´Â ´Ü¾î ¡ºthriller¡»°¡ Æ÷ÇÔµÈ ÅØ½ºÆ® ¹®¼¸¦ ã½À´Ï´Ù.
SELECT AUTHOR, TITLE FROM DB2EXT.TEXTTAB WHERE CONTAINS(COMMENT, '"th_iller"') = 1
Âü°í |
---|
¿ÍÀϵå Ä«µå ¹®ÀÚ¸¦ »ç¿ëÇÏ¸é °á°ú ¸ñ·ÏÀÇ Å©±â°¡ ÇöÀúÇÏ°Ô ´Ã¾î³ª¼ ¼º´ÉÀÌ ÀúÇÏµÇ°í ¿¹±âÄ¡ ¾ÊÀº °Ë»ö °á°ú°¡ ¸®ÅϵǹǷΠ»ç¿ë ½Ã ÁÖÀÇÇϽʽÿÀ. |