mysql myBatis 模糊查询的写法 r囧r小猫 2022-06-02 03:45 157阅读 0赞 <select id="getFormatList" resultMap="FormatListRVO"> <![CDATA[ SELECT T.FORMAT_ID formatId, T.FORMAT_NAME formatName, T.START_PLACE startPlace, T.END_PLACE endPlace, T.PLAY_DAYS playDays, T.CREATE_TYPE createType, date_format(R.START_DATE, '%Y/%d/%m') startDate, //时间格式转换 R.DEADLINE deadLine, R.END_DATE endDate FROM t_f_format T LEFT JOIN t_f_release R ON T.FORMAT_ID = R.FORMAT_ID AND R.DELFLAG = 0 WHERE T.DELFLAG = 0 ]]> <if test="formatName != '' and formatName != null"> AND T.FORMAT_NAME LIKE CONCAT('%',#{formatName},'%') //模糊查询 </if> LIMIT #{begin},#{count} //分页 </select>
还没有评论,来说两句吧...