mybatis按姓名或手机号搜索

1、AND ((USER_NAME LIKE '%'||#{searchKey}||'%') OR (MOBILE_PHONE LIKE '%'||#{searchKey}||'%'))
2、

<if test="phone != null and phone != ''">
    and MOBILE_PHONE like '%${phone}%'
</if>
<if test="name != null and name != ''">
    and EMPLOYEE_NAME like '%${name}%'
</if>