Oracle和Mysql中mybatis模糊匹配查询区别

首页 > 技术文章 > Oracle和Mysql中mybatis模糊匹配查询区别

lxcmyf 2018-04-27 12:44 原文

1.Oracle

SELECT  *  FROM USER WHERE 1=1 AND NAME LIKE '%'||#{name}||'%'

2.Mysql

SELECT  *  FROM USER WHERE 1=1 AND NAME LIKE "%"#{name}"%"