| | |
| | | AND cmp.remark = #{comMngPopulationVO.remark} </if> |
| | | <if test='comMngPopulationVO.keyWord != null and comMngPopulationVO.keyWord != ""'> |
| | | AND (cmp.`name` like concat (#{comMngPopulationVO.keyWord},'%') or |
| | | cmp.card_no_str = #{comMngPopulationVO.keyWord} or cmpct.label like concat ('%',#{comMngPopulationVO.keyWord},'%') |
| | | cmp.card_no_str = #{comMngPopulationVO.keyWord} or cmpct.label like concat ('%',#{comMngPopulationVO.keyWord},'%') or cmp.phone like concat ('%',#{comMngPopulationVO.keyWord},'%') |
| | | ) |
| | | </if> |
| | | </where> |