본문 바로가기
개발/Framework || Lib

ibatis like절 처리

by 백아절현 2008. 8. 22.
출처: http://theeye.pe.kr/186

MySQL :
SELECT * FROM tbl_name WHERE column_name LIKE "%$username$%"


ORACLE :
SELECT * FROM tbl_name WHERE column_name LIKE  '%' || #username# || '%'


SYBASE/SQL SERVER
SELECT * from tbl_name WHERE column_name LIKE  '%' + #username# + '%'







댓글