mybatis mysql 模糊查询_MyBatis Oracle MySQL DB2 SQLServer的like模糊查询

Oracle数据库：

select * from t_user where name like '%'||#{search_name}||'%'

或者

select * from t_user where name like concat(concat('%',#{search_name}),'%')

MySQL数据库：

select * from t_user where name like concat('%',#{search_name},'%')

或者

select * from t_user where name like "%"#{search_name}"%"

DB2数据库：

select * from t_user where name like concat('%',#{search_name},'%')

或者

select * from t_user where name like '%'||#{search_name}||'%'

SQLServer数据库：

select * from t_user where name like '%'+#{search_name}+'%'