# 原生写法
select * from user where username like '%${value}%'
1
注意:
${value}
里面必须要写value
,不然会报错
# oracle
数据库:
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%')
1
或 :
SELECT * FROM user WHERE name like '%'||#{name}||'%'
1
# SQLServer
数据库:
SELECT * FROM user WHERE name like '%'+#{name}+'%'
1
# mysql
数据库:
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%')
1
# DB2
数据库:
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%')
1
或
SELECT * FROM user WHERE name like '%'||#{name}||'%'
1
# 示例
<select id="queryRiskFlow" parameterType="java.util.Map" resultMap="FormRiskVo">
SELECT A.PROC_INST_ID_ ,B.STATUS_,B.PROC_DEF_ID_,C.* FROM
BPM_BUS_LINK A,BPM_PRO_INST B,FORM_RISK C
where A.PROC_INST_ID_ = B.ID_
AND A.BUSINESSKEY_STR_ = C.ID_
<if test="name!=null">
AND C.NAME LIKE '%' || #{name} ||'%'
</if>
<if test="orderBySql!=null">
ORDER BY ${orderBySql}
</if>
<if test="orderBySql==null">
ORDER BY C.ID_ DESC
</if>
</select>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15