½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
asp
CSS
HTML
mysql
jquery
image
Mobile
API
slide
°Ô½ÃÆÇ
¸Þ´º
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 51 | Á¶È¸¼ö 9,249 | µî·ÏÀÏ 2001-06-19 12:06:40

´Ð³×ÀÓ

vopos

À̸ÞÀÏ

vopos@happycgi.com

Á¦¸ñ

[´äº¯] [Áú¹®] 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

/----------------------------------------------------------------------------------------------------
ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż­ ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö
È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù.
----------------------------------------------------------------------------------------------------/
Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
ÀÌÀü°Ô½Ã±Û ÀúµÎ °°Àº ¿¡·¯....¤Ð.¤Ð 2001-06-19 03:17:24
´ÙÀ½°Ô½Ã±Û [Áú¹®] ²À Á» ´äÇØÁÖ¼¼¿ä...ÇïÇÁ¹Ì~ 2001-06-19 16:11:00