°¢ DBMS¿¡ µû¸¥ ibatis¿¡¼ like °Ë»ö
MySQL¿¡¼ LIKE°Ë»öÄõ¸®¸¦ ÀÛ¼ºÇÏ´øÁß, LKIE°Ë»öÀÌ ³»°¡ ÀÚÁÖ »ç¿ëÇÏ´ø ORACLE°ú Ʋ·Á¼ Á¤¸®Çغ¸¾Ò´Ù
MySQL :
SELECT * FROM tbl_name WHERE column_name LIKE "%$username$%"
SELECT * FROM tbl_name WHERE column_name LIKE CONCAT('%', #username#, '%')
ORACLE :
SELECT * FROM tbl_name WHERE column_name LIKE '%' || #username# || '%'
SYBASE/SQL SERVER
SELECT * from tbl_name WHERE column_name LIKE '%' + #username# + '%'
º¯¼ö¸íÀ» #·Î µÑ·¯½Î´Â °Í°ú $·Î µÑ·¯½Î´Â°ÍÀÇ Â÷ÀÌÁ¡
#ÀÇ °æ¿ì¿¡´Â Prepare Statement·Î µî·ÏÀÌ µÈ´Ù. µð¹ö±×¸¦ Âï¾îºÁµµ ?·Î ġȯµÈ ÀÌÈÄ °ªÀÌ ´ëÀԵȴÙ.
ÇÏÁö¸¸ $ÀÇ °æ¿ì ¹Ù·Î °ªÀÌ Ä¡È¯µÈ´Ù. ƯÁ¤ º¯¼ö°¡ ¹Ù·Î DB¿¡ ÀԷµǹǷΠº¸¾È¿¡ Á»´õ ½Å°æÀ» ½á¾ß ÇÒ°ÍÀ¸·Î »ý°¢µÈ´Ù.
µÉ¼öÀÖÀ¸¸é LIKE CONCAT('%', #username#, '%')°ú °°Àº ¹æ¹ýÀ» »ç¿ëÇÏ´Â°Ô ÁÁÀ» µí ÇÏ´Ù.
Ãâó: http://devx.tistory.com/entry/°¢-DBMS¿¡-µû¸¥-ibatis¿¡¼-like-°Ë»ö [Meta Developer Story]