<selectid="queryPageListByParams"parameterType="java.util.Map"resultMap="userMap">
SELECT
<includerefid="Base_Column_List"/>
FROM
user u
WHERE 1 = 1
<!--地址模糊查询 --><iftest="params.address!= null and params.address!= ''">
and res.name like CONCAT(CONCAT('%',#{params.name}),'%')
</if><iftest="params.keyWorod != null and params.keyWorod!= ''">
and INSTR(CONCAT_WS("-", name, sex), #{keyword}) > 0
</if>
order by create_time desc
</select>