like concat (‘%’,#{selectword},‘%’)
例如:
<select id="getList" resultType="com.qike.domain.DataVO"> SELECT * FROM host_sjfd where grade like concat('%',#{selectword},'%') </select>