oracle中一个关键字搜索多个列
<select id="getList" resultType="com.cxmt.modules.vo.ServiceVo">
SELECT si.id,si.NUMBER
FROM SERVICE si
JOIN law lf ON si.FIRMID =lf.id AND lf.del_flag=0
LEFT JOIN sys_user s ON si.USERID =s.ID AND s.DEL_FLAG =0
<where>
<if test="keyword != null and keyword !='' ">
AND CONCAT(
CONCAT(
CONCAT(CONCAT(NVL(si.CONSULTATION_NUMBER, ''), NVL(si.DEMAND_TYPE, '')), NVL(si.MODULAR_ID, '')),
NVL(si.SERVICE_HOURS, '')
), NVL(s.REALNAME, '')) like concat(concat('%',#{keyword}),'%')
</if>
</where>
</select>