ȨÀ¸·Î | ¹«·áȸ¿ø°¡ÀÔ | ¾ÆÀ̵ð/ºñ¹øÃ£±â
ÃßõÀ½¾Ç¹æ¼Û
[MySQL] Çʵ忡¼­ ƯÁ¤¹®ÀÚ Æ÷ÇÔ ¶Ç´Â Á¦¿ÜÇÑ DB °Ë»ö, LIKE ,NOT
6³â Àü
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 ¿É¼ÇÀº ³»¸²Â÷¼ø... Âü°í·Î ±âº»Àº ¿À¸§Â÷¼ø
ÃßõÃßõ : 334 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
3,030
 Á¦ÀÌÄõ¸® ±âº» ¸í·É¾î
3,029
 À¥ÆäÀÌÁö °¡·Î ¸ðµå¼¼·Î ¸ðµå ÀνÄÇϱâ
3,028
 ¸ð¹ÙÀÏ À¥ È­¸é °­Á¦ ȸÀü(°¡·Î¸ðµå °íÁ¤)
3,027
 [HTML5]¿¡¼­ frameset ´ëü ¹æ¹ý°ú iframe ¼Ó¼º
3,026
 HTML <Audio> »ç¿ë¹ý
3,025
 À©µµ¿ì10 ½Ã½ºÅÛÆÄÀÏ ¼Õ»ó (Ãʰ£´Ü ¿À·ù º¹±¸¹æ¹ý!!)
3,024
 PHP ÆÄÀÏ Á¸Àç ¿©ºÎ ÆÄ¾ÇÇϱâ(·ÎÄà ÆÄÀÏ Á¸Àç ¹× ¿ø°ÝÁö ÆÄÀÏ Á¸Àç)
3,023
 [CSS] ¹Ú½º ¼¼·Î °¡¿îµ¥ Áß¾Ó Á¤·Ä 6°¡Áö
3,022
 CSS Layout ¼öÆò & ¼öÁ÷ Á¤·Ä
3,021
 ¿©·¯ µµ¸ÞÀÎµé °£ ÄíŰ °øÀ¯Çϱâ
3,020
 ÅÂ±× »çÀÌ¿¡ ÀÖ´Â ÅØ½ºÆ®¸¦ ÃßÃâ
3,019
 [JQuery] textbox focus on offÀ϶§ ¼ýÀÚ ÄÞ¸¶ º¸¿©ÁÖ±â
3,018
 ÄíŰ »ý¼º,°¡Á®¿À±â,»èÁ¦
3,017
 »ç¿ëÀÚ ÇÔ¼ö ¸ðÀ½
3,016
 ¸¶¿ì½º,Űº¸µå Á¦ÇÑ ( ¿À¸¥ÂÊŬ¸¯,µå·¡±×,¿µ¿ª¼±Åõî..)
3,015
 [HTML5] <video> - DOMÀ¸·Î Á¦¾îÇϱâ
3,014
 HTML5 video ű׿¡¼­ ¿µ»ó Á¿ì¹ÝÀü
3,013
 PHP - ƯÁ¤ ÅÂ±× ¹× ¹®ÀÚ¿­ ÃßÃâ, Á¦°Å
3,012
 [PHP] define°ú definedÀÇ Â÷ÀÌ
3,011
 ¿ìŬ¸¯ ¿Ïº®Â÷´Ü ½ºÅ©¸³Æ®
3,010
 iframe ³ôÀÌ 100% ¸ÂÃß±â
3,009
 curl ÇÔ¼ö¸¦ ÀÌ¿ëÇÑ HTTP REFERER º¯°æ
3,008
 À©µµ¿ì10 ½Ã½ºÅÛ ÆÄÀÏ ¹× Dism °Ë»ç
3,007
 ÅؽºÆ® ÁٹٲÞ, ±ÛÀÚÀÚ¸£±â CSS
3,006
 jQuery Mobile¿¡¼­ À¯¿ëÇÑ ÄÚµå 10°¡Áö.
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æÄ§
Copyright (C) musictrot All rights reserved.