SELECT
*
FROM
user
WHERE
name LIKE CONCAT('%',#{name},'%')
name
LIKE
CONCAT(
'%'
,#{
},
)
或
name LIKE '%'||#{name}||'%'
||#{
}||
name LIKE '%'+#{name}+'%'
+#{
}+
WHERE 1 = 1
1 = 1
<if test="name != null and name != ''">
<if test=
"name != null and name != ''"
>
<bind name="pattern" value="'%' + _parameter.name + '%'" />
<bind
=
"pattern"
value=
"'%' + _parameter.name + '%'"
/>
AND name LIKE #{pattern}
AND
#{pattern}
</if>
因篇幅问题不能全部显示，请点此查看更多更全内容