ORACLE
Oracle, mysql, mariadb, sql server(mssql) prestatement LIKE query
엘로드넷
2019. 1. 8. 21:41
Oracle :
LIKE '%' || #searchKeyword# || '%'
MySQL(MariaDB) :
LIKE CONCAT('%', #{searchKeyword}, '%')
Sql Server (MSSQL) :
LIKE '%' + #searchKeyword# + '%'