MySQL的sql大于号(小于号)的使用

MyBatisPlus框架sql书写时,有关大于或小于号的使用,如果不拼接sql(查询时条件拼接)直接>或<即可,如果拼接sql的话,需要使用 &gt; 和&lt;进行比较.示例代码如下:

@Select("<script>" + "SELECT detail.latoId,IFNULL(detail.classify,) AS classify,detail.latoId AS maintainId,plan.planNo,detail.machineName," + "detail.machineId,detail.maintainDate AS planDate,detail.lastMaintainDate,detail.lastMaintenanceContent,detail.maintenanceContent,detail.model " + " from " + EntityMap.MAINTAIN_INFO + " AS plan" + " LEFT JOIN " + EntityMap.MAINTAIN_DETAIL + " AS detail ON plan.latoId=detail.formId " + " LEFT JOIN " + EntityMap.DEVICE_INFO + " AS info ON detail.machineId=info.machineId " + " where detail.maintainDate &lt; DATE(NOW()) " + "<if test=time !=null > AND detail.maintainDate &gt; #{time} </if>" + "<if test=endTime !=null > AND detail.endDate BETWEEN detail.endDate AND #{endTime} </if>" + "<if test=shop !=null > AND info.department=#{shop} </if>" + "<if test=classify !=null > AND detail.classify=#{classify} </if>" + "<if test=item !=null > AND detail.maintenanceContent like concat(concat(%,#{item},%)) </if>" + " ORDER BY plan.planDate DESC limit #{startRow},#{pageSize}" + "</script>")