[MySQL] Çʵ忡¼ ƯÁ¤¹®ÀÚ Æ÷ÇÔ ¶Ç´Â Á¦¿ÜÇÑ DB °Ë»ö, LIKE ,NOT |
|
|
|
7³â Àü
|
MySQLÀ» ºñ·ÔÇÑ Äõ¸®¾ð¾î¿¡¼ °¡Àå ¸¹ÀÌ »ç¿ëµÇ´Â °ÍÀÌ ¹Ù·Î µ¥ÀÌÅÍ Á¶È¸¿¡ »ç¿ëµÇ´Â select ¹®À̶ó°í »ý°¢µÇ³×¿ä. ÀÌ select¹®À» »ç¿ëÇØ Äõ¸®¹®À» Â¥´Â °Í ¿ª½Ã ¸¸¸¸Ä¡ ¾ÊÀº ÀÛ¾÷ÀÔ´Ï´Ù.
select¹®À» »ç¿ëÇÏ¿© ¿øÇÏ´Â Á¤º¸¸¸ °¡Á®¿À±â À§Çؼ´Â select¹®°ú ÇÔ²² »ç¿ëµÇ´Â ´Ù¾çÇÑ Å°¿öµå¸¦ È°¿ëÇØ¾ß ÇÒ °ÍÀÔ´Ï´Ù. ´ëÇ¥ÀûÀ¸·Î where, and, or, between ±×¸®°í like µîµî Á¤¸» ¸¹ÀÌ Á¸ÀçÇÏÁÒ. ±âÈ£µµ ¹°·ÐÀÔ´Ï´Ù. || , % µîµî... ÀÌ ¸ðµç °ÍÀ» Á¤¸®ÇÏ¿© ¾î¶»°Ô »ç¿ëÇÏ´ÂÁö ¾Ë¾Æº¸°íÀÚ ÇÕ´Ï´Ù :)
¾Æ·¡ÀÇ ¿¹Á¦µéÀº ÀÌ ´Ù¾çÇÑ ¹æ¹ýÀ» »ç¿ëÇÏ¿© Å×À̺í¾È¿¡ ÀÖ´Â Çʵ忡¼ ¿øÇÏ´Â °ª¸¸ ã´Â ¹æ¹ýµéÀÔ´Ï´Ù. like, notÀ» ÀÌ¿ëÇÑ ¹æ¹ý¿Ü¿¡µµ ¿©·¯°¡Áö¸¦ ÇÔ²² Á¤¸®ÇÏ¿´À¸´Ï ¾Æ·¡ ¿¹Á¦¸¦ Âü°íÇØ Äõ¸®¹®À» Â¥½Ã´Âµ¥ µµ¿òÀÌ µÇ¸é ÁÁ°Ú½À´Ï´Ù.
! select »ç¿ë ¿¹Á¦ÄÚµå¿Í ÇÔ²² ¾Ë¾Æº¸±â
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 ¿É¼ÇÀº ³»¸²Â÷¼ø... Âü°í·Î ±âº»Àº ¿À¸§Â÷¼ø |
|
̵̧ : 303 |
̵̧
¸ñ·Ï
|
|