mapper映射器中if标签的应用

<where>
p.del_flag = #{DEL_FLAG_NORMAL}
<if test="clientName != null and clientName != ''">
AND p.client_name = #{clientName}
</if>
<if test="projectStatus != null and projectStatus != ''">
<if test='projectStatus == "0"'>
AND p.is_name = '1'
</if>
<if test='projectStatus == "1"'>
AND p.is_fail = '1'
</if>
<if test='projectStatus == "2"'>
AND FLOOR((UNIX_TIMESTAMP(SYSDATE()) - UNIX_TIMESTAMP(p.update_date))/(60*60*24)) >= 30 
</if>
<if test='projectStatus == "3"'>
AND FLOOR((UNIX_TIMESTAMP(SYSDATE()) - UNIX_TIMESTAMP(p.create_date))/(60*60*24)) >= 60
</if>
</if>

</where>

<if test='projectStatus == "0"'> 这里只能用单引号包双引号,不能用双引号包单引号