ȸ¿ø°¡ÀԡžÆÀ̵ð/ºñ¹øã±â
ȨÀ¸·Î

[MySQL] Çʵ忡¼­ ƯÁ¤¹®ÀÚ Æ÷ÇÔ ¶Ç´Â Á¦¿ÜÇÑ DB °Ë»ö, LIKE ,NOT
8³â Àü
SELECT * FROM tablename WHERE who="me";
// who Çʵ忡¼­ "me"¸¦ °¡Áø µ¥ÀÌÅ͸¦ ãÀ»¶§...

SELECT * FROM tablename WHERE who LIKE "%me%";
// who Çʵ忡 ¾ÕµÚ¿¡ ¾î¶² ¹®ÀÚ°¡ ¿Íµµ »ó°ü ¾øÀÌ me¸¦ °¡Áø µ¥ÀÌÅÍ °Ë»öÇϱâ


/* ¾Æ·¡´Â, ¾Õ ¶Ç´Â µÚ¿¡ ¾î¶² ¹®ÀÚ°¡ ¿Íµµ »ó°ü ¾ø´Â °æ¿ì */
SELECT * FROM tablename WHERE who LIKE "%me";
// ¾Õ¿¡ ¹®ÀÚ ¹«½Ã
SELECT * FROM tablename WHERE who LIKE "me%";
// µÚ¿¡ ¹®ÀÚ ¹«½Ã

SELECT * FROM tablename WHERE NOT who="me";
// who Çʵ忡 "me"¸¦ Á¦¿ÜÇÑ µ¥ÀÌÅÍ

SELECT * FROM tablename WHERE filed1 LIKE "%me%" AND filed2 LIKE "%you%";
// me¸¦ °¡Áø °ªÀÇ ¾ÕµÚ ¹®ÀÚ¸¦ ¹«½ÃÇÏ°í µ¿½Ã¿¡ youÀÇ ¾ÕµÚÀÇ °ªÀ» ¹«½ÃÇÑ µ¥ÀÌÅ͸¦ °¡Á®¿È


/* ¾Æ·¡¿Í °°ÀÌ % ±âÈ£¸¦ ´Ù¼ö »ç¿ëÇÒ ¼öµµ ÀÖ½À´Ï´Ù. */
; SELECT * FROM TABLE WHERE FIELD1 LIKE ¡¯%me%you%¡¯;
// °£´ÜÇϸ鼭 ¸Å¿ì À¯¿ëÇÏ°Ô »ç¿ë °¡´É. ƯÈ÷ º¹¼ö°³ÀÇ À妽º °Ë»ö½Ã ´õ¿í ÇÊ¿ä


±× ¿Ü ±âŸ ¿¹Á¦µéÀÔ´Ï´Ù.

SELECT * FROM tablename WHERE who LIKE "%me%" OR who LIKE "%you%";
// ORÀº AND¿Í ´Þ¸® A ¶Ç´Â B¿Í °°ÀÌ µÑ Áß Çϳª¸¸ ¸¸Á·Çصµ µ¥ÀÌÅ͸¦ ºÒ·¯¿È

SELECT * FROM tablename WHERE who LIKE "%me%" OR NOT who LIKE "%you%";
// µÚ¿¡ NOTÀÌ µé¾î°¡´Â °æ¿ì ÇÊµå ¾Õ¿¡ ½á¾ßÇÔ

SELECT * FROM tablename WHERE who=test AND (who LIKE "%me%" OR NOT who LIKE "%you%");
// À§¿Í °°ÀÌ °ýÈ£¸¦ ¹­¾î¼­ ¿ì¼±¼øÀ§ ÁöÁ¤ÀÌ °¡´É

SELECT * FROM tablename WHERE who < 100 AND who > 10;
// ¼ýÀÚ µ¥ÀÌÅÍÀÇ °æ¿ì ºÎµîÈ£ÀÇ »ç¿ëÀÌ °¡´É

SELECT * FROM tablename WHERE who < 100 AND who > 10 ORDER BY DATE;
// DATE¶õ Çʵ带 ±âÁØÀ¸·Î Á¤·ÄÀ» ¿äûÇÔ

SELECT * FROM tablename WHERE who < 100 AND who > 10 ORDER BY DATE DESC;
// DESC ¿É¼ÇÀº ³»¸²Â÷¼ø... Âü°í·Î ±âº»Àº ¿À¸§Â÷¼ø
ÃßõÃßõ : 406 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
2,735
[jQuery]toggleClass() ¸Þ¼­µå·Î CSS Ŭ·¡½º¿¡ ´ëÇÑ Åä±×¸µ
2,734
JQuery ¸Þ¼­µå Çѹø¸¸ ½ÇÇà ( One() )
2,733
jQuery Event(À̺¥Æ®¿¡ »ý¸íÀ»)
2,732
jQuery Event - bind() ¸Þ¼­µå¸¦ ÅëÇÑ À̺¥Æ® ¿¬°á
2,731
escapeshellcmd
2,730
passthru
2,729
system
2,728
exec
2,727
proc_open
2,726
popen
2,725
fgetc
2,724
fgets
2,723
fclose
2,722
fopen
2,721
fsockopen
2,720
stream_set_timeout
2,719
JQUERY Ŭ¸¯ À̺¥Æ® °­Á¦ ¹ß»ý
2,718
ajaxComplete() Ajax°¡ ¿Ï·áµÇ¸é È£Ãâ
2,717
ajaxError() Ajax ¿¡·¯°¡ ¹ß»ýµÇ¸é È£Ãâ
2,716
jQuery.ajaxPrefilter() $.ajax() ÇÔ¼ö È£Ãâ Àü Ajax ¿É¼Ç ¼öÁ¤
2,715
ajaxSend() Ajax ¿äûÀ» º¸³»±â Àü¿¡ È£ÃâµÇ´Â À̺¥Æ®
2,714
jQuery.ajaxSetup() Ajax ¿É¼Ç °ªÀ» ¼³Á¤ÇÏ´Â ÇÔ¼ö
2,713
ajaxStart() Ajax ¿äûÀÌ ½ÃÀÛµÉ ¶§ È£ÃâµÇ´Â ÇÔ¼ö
2,712
ajaxStop() Ajax ¿äûÀÌ ¿Ï·áµÇ¸é È£Ãâ
2,711
ajaxSuccess() Ajax ¿äûÀÌ ¼º°øÀûÀ¸·Î ¿Ï·á ¶§¸¶´Ù È£Ãâ
2,710
jQuery.getScript, JavaScript ÆÄÀÏÀ» ·ÎµåÇÏ°í ½ÇÇà
2,709
load(), Ajax·Î ¹ÞÀº HTMLÀ» ÀÏÄ¡ÇÏ´Â ¿ä¼Ò ¾È¿¡ Ãß°¡
2,708
jQuery.param(), Ajax µ¥ÀÌÅÍ¿ë ¹è¿­À̳ª °´Ã¼¸¦ Á÷·ÄÈ­
2,707
jQuery.get() HTTP GET ¹æ½Ä Ajax ¿äû
2,706
jQuery.post(), Ajax HTTP POST ¹æ½Ä ¿äû
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æħ
Copyright ¨Ï musictrot All rights reserved.