|
Total related article : 3 |
|
µî·ÏÀÏ: | 2001-08-17 |
½Ã°£: | 20:18:03 |
Á¶È¸¼ö: | 2178 |
from: | 211.187.172.55 |
|
[Áú¹®] ¾È³çÇϼ¼¿©... ±ÞÁú¹®.... |
±Û¾´ÀÌ : progkim3 |
|
¾È³çÇϼ¼¿©... DB¿¬µ¿ º¸µå¸¦ ¸¸µé¾î ¾²°í ÀÖ´Â ³ðÀä...¹°·Ð PERL...
¿À´Ã ½ºÅ² ¹Ù²Ù´Ù°¡ ÇÑ°¡Áö ¹ö±×°°Àº°Ô ¹ß°ßµÇ¼¿ä.....
°Ë»öÀ¸·Î.......
$sth = $dbh->prepare("SELECT * FROM board WHERE title LIKE '%$FORM{'Keyword'}%'");
ÀÌ·±½ÄÀ¸·Î °Ë»öÇϰŵç¿ä...¹°·Ð °Ë»ö ¹æ¹ýÀº 3°¡Áö À̱¸¿ä....
±Ùµ¥ ¿©±â¼ ¹®Á¦´Â A¶ó´Â ¿µ¹®ÀÚ¸¦ ¼Ò¹®ÀÚµç ´ë¹®ÀÚµç ÀÌ°Å Çϳª¸¸ ³Ö°í °Ë»öÇÏ¸é ¸ðÁ¶¸®´Ù °Ë»öµÈ´Ù´Â °Çµ¥¿©....
¿ø·¡ MYSQL¿¡¼ ±×·¯³ª º¸ÁÒ? ¿ö¶»°Ô ó¸®?
|
|
   |
|
µî·ÏÀÏ: | 2001-08-18 |
½Ã°£: | 22:08:16 |
Á¶È¸¼ö: | 2449 |
from: | 211.187.172.55 |
|
[´äº¯] [Áú¹®] ¾È³çÇϼ¼¿©... ±ÞÁú¹®.... |
±Û¾´ÀÌ : HappyCGI |
|
>¾È³çÇϼ¼¿©... >DB¿¬µ¿ º¸µå¸¦ ¸¸µé¾î ¾²°í ÀÖ´Â ³ðÀä...¹°·Ð PERL... > >¿À´Ã ½ºÅ² ¹Ù²Ù´Ù°¡ ÇÑ°¡Áö ¹ö±×°°Àº°Ô ¹ß°ßµÇ¼¿ä..... > >°Ë»öÀ¸·Î....... > >$sth = $dbh->prepare("SELECT * FROM board WHERE title LIKE '%$FORM{'Keyword'}%'"); > >ÀÌ·±½ÄÀ¸·Î °Ë»öÇϰŵç¿ä...¹°·Ð °Ë»ö ¹æ¹ýÀº 3°¡Áö À̱¸¿ä.... > >±Ùµ¥ ¿©±â¼ ¹®Á¦´Â A¶ó´Â ¿µ¹®ÀÚ¸¦ ¼Ò¹®ÀÚµç ´ë¹®ÀÚµç ÀÌ°Å Çϳª¸¸ >³Ö°í °Ë»öÇÏ¸é ¸ðÁ¶¸®´Ù °Ë»öµÈ´Ù´Â °Çµ¥¿©.... > >¿ø·¡ MYSQL¿¡¼ ±×·¯³ª º¸ÁÒ? >¿ö¶»°Ô ó¸®?
¾È³çÇϼ¼¿ä. ÇØÇÇCGI À¥¸¶½ºÅÍ À±¿µ¿õÀÔ´Ï´Ù.
select "a" = "A"; Âü°ªÀÎ 1 À» ¹Ýȯ select BINARY "a"="A"; °ÅÁþ°ªÀÎ 0 À» ¹Ýȯ
¿Í °°ÀÌ BINARY¸¦ »ç¿ëÇÏ¸é ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇØÁÝ´Ï´Ù. ±âº»ÀûÀ¸·Î ´ë¼Ò¹®ÀÚ ±¸ºÐÀÌ ¾ø½À´Ï´Ù.
ÁÁÀº ÇÏ·çµÇ¼¼¿ä.
|
|
   |
|
µî·ÏÀÏ: | 2002-09-27 |
½Ã°£: | 17:29:58 |
Á¶È¸¼ö: | 2412 |
from: | 203.238.195.12 |
|
      Re: [Áú¹®] ¾È³çÇϼ¼¿©... ±ÞÁú¹®.... |
±Û¾´ÀÌ : vopos |
|
"±èµ¿°" ´Ô Àοë±Û
¾È³çÇϼ¼¿©... DB¿¬µ¿ º¸µå¸¦ ¸¸µé¾î ¾²°í ÀÖ´Â ³ðÀä...¹°·Ð PERL...
¿À´Ã ½ºÅ² ¹Ù²Ù´Ù°¡ ÇÑ°¡Áö ¹ö±×°°Àº°Ô ¹ß°ßµÇ¼¿ä.....
°Ë»öÀ¸·Î.......
$sth = $dbh->prepare("SELECT * FROM board WHERE title LIKE '%$FORM{'Keyword'}%'");
ÀÌ·±½ÄÀ¸·Î °Ë»öÇϰŵç¿ä...¹°·Ð °Ë»ö ¹æ¹ýÀº 3°¡Áö À̱¸¿ä....
±Ùµ¥ ¿©±â¼ ¹®Á¦´Â A¶ó´Â ¿µ¹®ÀÚ¸¦ ¼Ò¹®ÀÚµç ´ë¹®ÀÚµç ÀÌ°Å Çϳª¸¸ ³Ö°í °Ë»öÇÏ¸é ¸ðÁ¶¸®´Ù °Ë»öµÈ´Ù´Â °Çµ¥¿©....
¿ø·¡ MYSQL¿¡¼ ±×·¯³ª º¸ÁÒ? ¿ö¶»°Ô ó¸®? |
MySQL¿¡¼ Áö¿øÇÏ´Â µ¥ÀÌŸ ŸÀÔÁß¿¡ blob°ú text°¡ Àִµ¥¿ä. Â÷ÀÌÁ¡Àº...
blob: case sensitive text: case insensitive
¶ó°í ¸Þ´º¾ó¿¡ µÇ¾îÀÖÀ»°Ì´Ï´Ù. (¿À·¡µÅ¼ °¡¹°°¡¹° ÇÕ´Ï´Ù. µÚÁý¾î Á³À»Áöµµ...)
°Ë»öµÉ Ä÷³ÀÇ µ¥ÀÌŸ ŸÀÔÀ» blobÀ¸·Î ÇØÁÖ¸é ´ë¼Ò¹®ÀÚ ±¸ºÐÇؼ °Ë»öµÉ°Í °°¾Æ¿ä.
|
|
   |