|
|
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ À¥µðºñ : °Ô½Ã¹° Àбâ |
|
|
  2001-06-19 (12:06:40) from 211.33.8.94 |
|
|
  ÀÛ¼ºÀÎ : vopos |
Á¶È¸¼ö : 9773    |
|
Á¦¸ñ : [´äº¯] [Áú¹®] mysql¿¡¼ °Ë»öÇßÀ»¶§... blobÀÇ ¹®Àå¿¡¼... |
¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.
>°Ô½ÃÆÇÀÇ °æ¿ì blobÀ¸·Î º»¹®À» ¸¸µé¾î µÐ´Ù°í Çϸé... >º»¹® °Ë»öÀ» ÇÏ¿© blob¹® ¾È¿¡¼ '¾È³ç' À̶ó´Â ´Ü¾î¸¦ ã½À´Ï´Ù. >À̶§ ¾È³çÀ» Æ÷ÇÔÇÏ¿© ¾à 30±ÛÀÚÀÇ ±ÛÀÚ¸¦ ... > > ... ±×¿¡°Ô ¾È³ç À̶ó°í ¸»ÇÏ°í µ¹¾Æ¼¹´Ù ... > >¿Í °°Àº ½ÄÀ¸·Î Ç¥ÇöÇÏ·Á¸é ¾î¶»°Ô ÇÏÁÒ? >¿ä¾àÇϸé mysql¿¡¼ °Ë»öÇßÀ»¶§ °Ë»ö¹®À» ±âÁØÀ¸·Î Á¿ì x±ÛÀÚ¸¸ÅÀÇ >¹®ÀåÀ» »Ì¾Æ³»¼ Ãâ·ÂÇÒ¶§.... ÀÌ´Â perl·Î ±¸ÇöÇÏ·Á°í ÇÕ´Ï´Ù.
Á¤±ÔÇ¥Çö½Ä(regular expression)¿¡ ´ëÇÑ Áö½ÄÀÌ ÇÊ¿äÇÒ µí ÇÕ´Ï´Ù. ÇØÇÇÆ÷·³¿¡µµ ¾îµð¿£°¡ ¼³¸íÀÌ ÀÖÀ¸´Ï ã¾Æº¸½Ã°í, Á¦°¡ ¾Ë°íÀÖ´Â ±âÃʸ¦ ¼³¸íÇصРÆäÀÌÁö¸¦ ¸µ Å© ½ÃÄѵ帳´Ï´Ù.
http://www.phpschool.com/bbs/view.html?id=2278&code=tnt&start=0 http://www.devshed.com/Server_Side/Administration/RegExp/ http://www.phpbuilder.com/columns/dario19990616.php3 http://www.mysql.com/doc/P/a/Pattern_matching.html http://public.yahoo.com/~jfriedl/regex/links.html
>±×¸®°í¿ä...blobÀº indexÁ¤ÀÇ ÇÒ¼ö ¾ø´Â°Ì´Ï±î?
TEXT, BLOB ÇüÅ´ MySQL¿¡¼ INDEX°¡ µÇÁö ¾Ê´õ±º¿ä. ¾Æ¸¶ µ¥ÀÌŸ Å©±â°¡ Å©±â ¶§¹®ÀÌ ¾Æ´Ñ°¡ »ý°¢µÇ´Âµ¥¿ä.
MySQL 3.23.23 ÀÌÈĺÎÅÍ´Â VARCHAR, TEXT ·Î Á¤ÀÇµÈ Ä÷³À» À妽º ÇÒ ¼ö ÀÖ´Ù°í µÇ¾î Àִµ¥ Çѹø Çغ¸½Ã°í ±ÛÁÖ¼¼¿ä.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
°¨»çÇÕ´Ï´Ù.
- vopos
/---------------------------------------------------------------------------------------------------- ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù. ----------------------------------------------------------------------------------------------------/
|
|
¸Þ¸ð |
|
³²°ÜÁø ¸Þ¸ð°¡ ¾ø½À´Ï´Ù.
|
|
   |
|
|