IBATIS/myBatis
2017.04.27 / 19:41
MyBatis Like °Ë»ö½Ã 󸮹æ¹ý
Scoda
Ãßõ ¼ö 182
MyBatis / iBatis¿¡¼ Á¶°ÇÀý¿¡ Like °Ë»ö½Ã ó¸®ÇÏ´Â ¹æ¹ýÀÌ´Ù.
°Ë»öÇÏ°íÀÚ ÇÏ´Â Çʵå¸íÀÌ "title" ÀÌ°í ÇØ´ç Çʵ忡¼ °Ë»öÇÒ ³»¿ëÀ» ÆĶó¹ÌÅ͸¦ "keyword" ¶ó°í ÇÏ¸é ¾Æ·¡¿Í °°ÀÌ °Ë»öÇÒ ¼ö ÀÖ´Ù.
[MySQL]
title like CONCAT('%',#{keyword},'%')
[Oracle]
title like '%' || #{keyword} || '%'
[MSSQL]
title like '%' + #{keyword} + '%'
Á¤¸® : °¢ DBMS¿¡ ¸Â°Ô ¹®ÀÚ¿ ÇÕÄ¡±â ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ÀÌ¿ëÇÏ¸é µÈ´Ù.
Ãâó: http://fruitdev.tistory.com/60 [°úÀÏ°¡°Ô °³¹ßÀÚ]